Re: Question about DBMS_UTILITY.GET_TIME

On Windows NT it's the number of 1/100 seconds since the OS started (not the database). It wraps each circa 50 days.

HTH. Finn

Heiko Binsau <binsau_at_stn-atlas.de> wrote in message news:38E84CA3.17907F0C_at_stn-atlas.de...
> Hello,
>
> I'm using the function GET_TIME of the DBMS_UTILITY-package. It seems to
> me that the functionality from Oracle 8.0.5 to 8.1.5 has changed.
>
> The manual of Oracle 8.1.5 describes GET_TIME as follows:
> "
> This function finds out the current time in 100th's of a second. It is
> primarily useful for determining elapsed
> time.
>
> Syntax
>
> DBMS_UTILITY.GET_TIME
> RETURN NUMBER;
>
> Parameters
>
> None.
>
> Returns
>
> Time is the number of 100th's of a second from some arbitrary epoch.
> "
>
> Does anyone know what "some arbitrary epoch" means?!
>
>
> Thanks for help,
>
> Heiko
>
> --
> --------------------------------------------------------------
> Heiko Binsau eMail: binsau_at_STN-Atlas.de Tel: 0421 457-1573
> --------------------------------------------------------------
Received on Tue Apr 04 2000 - 00:00:00 CDT