OraFAQ Forum: Server Utilities » How to get millisecond information ... from date field..

Home » RDBMS Server » Server Utilities » How to get millisecond information ... from date field..

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to get millisecond information ... from date field.. [message #368286]

Fri, 27 October 2000 09:46

Prasad
Messages: 104
Registered: October 2000

Senior Member

Any help is appreciated

thnx

Report message to a moderator

Re: How to get millisecond information ... from date field.. [message #368287 is a reply to message #368286]

Fri, 27 October 2000 13:20

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;

Report message to a moderator

Previous Topic:	Cannot get into SQL PLUS!!
Next Topic:	Transporting Datafile

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun May 28 16:47:39 CDT 2023