Problem with Timestamp in SQL assistant

General
Enthusiast

Problem with Timestamp in SQL assistant

I have  a column with datatype time(6). When i try to retrieve data, i get data with timestamp but millisecs part missing.

Whereas when i run the same script in Bteq, i get the complete timestamp(millisecs part included).

Can ny1 plse help me with it.

5 REPLIES
Senior Apprentice

Re: Problem with Timestamp in SQL assistant

Which release of SQLA?

ODBC or .NET connection?

Dieter

Enthusiast

Re: Problem with Timestamp in SQL assistant

ODBC.

Teradata Employee

Re: Problem with Timestamp in SQL assistant

Have you tried .NET connection?

And can you provide example including DDL, sample data and SELECT statement you are using?

Regards, Adeel

Enthusiast

Re: Problem with Timestamp in SQL assistant

It may be helpful to know which version of ODCB and SQL Assistant you are using as well. 

Have you tried CAST(MyTimestamp6 AS CHAR(26)) in SQL Assistant to see if when returned to SQL Assistant as a CHAR() data type the Answerset grid control behaves differently? (Sounds crazy but I have my reservations about that grid.)

Enthusiast

Re: Problem with Timestamp in SQL assistant

yes..even i hav also obeserved the same thing with SQLA. Try with BTEQ. You will get the exact data.