Re: DBMS_UTILITY.GET

From: Andrew Hardy <spam.from.news_at_AdvanticaTech.com>
Date: Tue, 3 Dec 2002 09:15:28 -0000
Message-ID: <ashsno$anr$1@sun-cc204.lut.ac.uk>

JK,

"JK" <jim.katsos_at_oz.quest.com> wrote in message news:ashdt7$rce$1_at_perki.connect.com.au...
> If I run DBMS_UTILITY.GET_TIME I get the number of 100th's of a second
> from some arbitrary epoch.
>
> My question is can I get the approx time given a value returned by
GET_TIME.
> i.e the reverse of get time.
>
> Can I get the date time of the epoch ?

Have you tried taking the current time and then subtracting the get_time time (taking into account that it's in 100ths of a second)?

Andy Received on Tue Dec 03 2002 - 03:15:28 CST

Re: DBMS_UTILITY.GET_TIME