All Forums General
Bose3920 1 post Joined 03/15
21 Mar 2015
Diffrent values displayed for Timestamp (6) column on diffrent queries

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 
"nonsequenced transactiontime
SELECT TEMP
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
 

dnoeth 4628 posts Joined 11/04
22 Mar 2015

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:
ODBC (SQLA)
NET (SQLA)
JDBC (Studio)
CLI (BTEQ)
I usually trust BTEQ, so try this first :)

Dieter

You must sign in to leave a comment.