Return
-
Title
Timestamp columns displayed in data grid do not include milli seconds. -
Description
Timestamp columns displayed in data grid do not include milli seconds.
The timestamp is returned and displayed as 11/6/2012 9:53:26 AM, whereas when it's selected on other products it comes back as 2012-11-06 09:53:26.366000. How to get Toad to be able to display the true timestamp?
-
Resolution
1. Select Tools | Options menu option
2. Go under Environment | Grid section
3. Under DateTime tab, check “Custom” checkbox and enter: M-dd-yyyy h:mm:ss:ffff tt
4. Hit OK to close options