Home » SQL & PL/SQL » SQL & PL/SQL » detailed sysdate
detailed sysdate [message #107] Mon, 14 January 2002 23:06 Go to next message
Messages: 4
Registered: October 2000
Junior Member
is it possible to get the sysdate more detailed (1/10 and 1/100 seconds)?
Re: detailed sysdate [message #115 is a reply to message #107] Tue, 15 January 2002 03:04 Go to previous message
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.
Previous Topic: dELETE
Next Topic: Help in Oracle trigger
Goto Forum:

Current Time: Wed May 22 15:09:13 CDT 2024