Re: Micro-seconds in Oracle

Peter H. Larsen wrote:
>
> On Wed, 21 Jan 1998 08:39:30 GMT, kul_at_post3.tele.dk (Kurt Laugesen)
> wrote:
>
> >On Tue, 20 Jan 1998 12:03:25 +0100, John Nagtzaam <dmw_jnagtzaa_at_asd033.gak.nl> wrote:
> >
> >>Could anyone tell me how to get the current time in micro-seconds in
> >>Oracle ?
> >>
> >You can't! The smallest timescale in Oracle is a second
>
> Sorry - not true enteraly. But the lowest level of granularity in
> 100ths of a second. By calling DBMS_UTILITY.GET_TIME (function) the
> return NUMBER is 100ths of seconds since "somewhere". It's not the
> current time - but it's to be used as a mean to calculate 100ths of
> seconds of granularity between events. Read the GET_TIME value twice
> and deduct them from eachother.
>
> But correct - the DATE format only supports a granularity of seconds.
>
> Regards
> Peter H. Larsen (petlars_at_pip.dknet.dk)
> Oracle Consultant (not affiliated with Oracle)

I may be wrong - but I think it is the milliseconds since db startup

Cheers

-- 
==========================================
Connor McDonald
BHP Information Technology
Perth, Western Australia
"These views mine not BHP..etc etc"

"The only difference between me and a madman is that I am not mad."