Can I show milliseconds in TOAD ? [message #256947] |
Tue, 07 August 2007 04:36 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
bakkerf
Messages: 1 Registered: August 2007 Location: IJmuiden
|
Junior Member |
|
|
Is it possible to show milliseconds in TOAD 9.1 ?
TOAD is still saying, that the format to_CHAR("timestamp",'hh24:mi:ss ff') is wrong
|
|
|
|
Re: Can I show milliseconds in TOAD ? [message #256993 is a reply to message #256958] |
Tue, 07 August 2007 05:58 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
Received via Private Message | Hello Littlefoot,
"timestamp" is a field, but is imported from an other application where it was used as a date/time
Now is it loaded in this field with sysdate.
But your coding is stiil not working on the TOAD 9.1
I dit type select to_char(sysdate, 'hh24:mi:ss.ff2') from dual; and I get the message like "Datenotation unknown" but in Dutch
Thanks anyway
|
Please, do not communicate through Private Messages; doing so, noone will benefit from such a conversation.
On-topic:
If you need milliseconds, you'll have to use SYSTIMESTAMP, not SYSDATE (as it contains time down to seconds). Also, I forgot to mention my TOAD version: it is 8.6, so I believe that this code *must* work in higher version than mine.
|
|
|