I have a Temporal table with a temporal column named 'Temp' defined as 'Timestamp(6) with time Zone'. when i execute the below query. But again when i substitute this value inthe below query
"Select col1, col2,max(Begin(Temp)) from table "
my result set says
A , B , 2015-03-18 11:29:00.071000+01:00
But again when i substitute this value in the below query
FROM Table WHERE begin(TEMP) > '2015-03-18 11:29:00.071000+01:00' "
I receive the same row, but with a diffrence in the timestamp column (change highlighted with bold letters)
A , B , 2015-03-18 11:29:00.710000+01:00
Could somebody help me understand why this happens
The first timestamp will not be generated by Teradata (only two fractional digits).
Is this always shifting the fractional seconds one digit?
What client do you use?
Before you open an incident you should run it with different clients/connections to find out if this is a client/connection/DBMS problem:
I usually trust BTEQ, so try this first :)