| Can I show milliseconds in TOAD ? [message #256947] |
Tue, 07 August 2007 04:36  |
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  |
 |
Littlefoot
Messages: 21823
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
