| detailed sysdate [message #107] |
Mon, 14 January 2002 23:06  |
andreas
Messages: 4
Registered: October 2000
|
Junior Member |
|
|
is it possible to get the sysdate more detailed (1/10 and 1/100 seconds)?
thanks.
|
|
|
|
| Re: detailed sysdate [message #115 is a reply to message #107] |
Tue, 15 January 2002 03:04  |
Vishnu Bhavaraju
Messages: 6
Registered: January 2002
|
Junior Member |
|
|
|
Oracle stores the date in a number format - the number of days expired from the start of Julian calendar i.e, 4712 BC . The decimal place in that number gives the number of seconds expired in the last day . so the least detail you can get about time using sysdate is a second.
|
|
|
|
] 
Search
Help
Members
Register
Login
Home
