Diffrent values displayed for Timestamp (6) column on diffrent queries

General

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

1 REPLY
Junior Contributor

Re: Diffrent values displayed for Timestamp (6) column on diffrent queries

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 :)