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.
Have you tried .NET connection?
And can you provide example including DDL, sample data and SELECT statement you are using?
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.)