Home » SQL & PL/SQL » SQL & PL/SQL » detailed sysdate
detailed sysdate [message #107] Mon, 14 January 2002 23:06 Go to next message
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 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 Apr 08 23:43:42 CDT 2020