Home » RDBMS Server » Server Utilities » How to get millisecond information ... from date field..
How to get millisecond information ... from date field.. [message #368286] Fri, 27 October 2000 09:46 Go to next message
Prasad
Messages: 104
Registered: October 2000
Senior Member
Any help is appreciated

thnx
Re: How to get millisecond information ... from date field.. [message #368287 is a reply to message #368286] Fri, 27 October 2000 13:20 Go to previous message
Andrew
Messages: 144
Registered: March 1999
Senior Member
Oracle only stores timestamp data (datatype DATE) down to seconds. If you wanted to store it to a finer resolution, you'd have to add your own millisecond column. Date arithmetic would be a problem though.

DECLARE
timing PLS_INTEGER; -- more efficient than integer!
BEGIN
timing := DBMS_UTILITY.get_time;
--DO something...
DBMS_OUTPUT.put_line ('Delta = ' || TO_CHAR (DBMS_UTILITY.get_time - timing));
END;
Previous Topic: Cannot get into SQL PLUS!!
Next Topic: Transporting Datafile
Goto Forum:
  


Current Time: Fri Mar 29 04:20:05 CDT 2024