Our DB is Netezza and we are using Toad for Data Analysts to query the Netezza tables. Tables are having ‘Timestamp’ column with the format mm/dd/yyyy hh24:mi:ss.NS. When access this data from Toad for DA the Nano second part is getting truncated. Its only showing 000000 for Nano Second part. Can any one tell me what needs to be done to display the nano seconds? I have tried do the custom setting in Configuration -> Options -> environment -> grid -> Date format. But its not working.
The value is being converted to a .Net DateTime structure that does not have support for nano seconds.
So… There is no way to see the nano second values in Toad for DA?
No, you will not be able to see the fractional seconds with the default views in TDA. You could however use a calculated field to see the data.
Select col1, col2, tscol, EXTRACT(microsecond FROM tscol) / cast(1000000 as real)) as seconds from atable;
So if you have a value of 2001-02-16 20:38:40.5678 in the tscol then you should see 40.5678 in the seconds column.
Hope this helps.