Home » SQL & PL/SQL » Client Tools » Can I show milliseconds in TOAD ?
Can I show milliseconds in TOAD ? [message #256947] Tue, 07 August 2007 04:36 Go to next message
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 #256958 is a reply to message #256947] Tue, 07 August 2007 04:55 Go to previous messageGo to next message
Littlefoot
Messages: 20895
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
What is "timestamp" in your example?

./fa/2844/0/
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
Littlefoot
Messages: 20895
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.
Previous Topic: connection using sqlplus
Next Topic: disabling sqlplus output
Goto Forum:
  


Current Time: Tue Dec 06 00:14:01 CST 2016

Total time taken to generate the page: 0.05745 seconds