Re: Micro-seconds in Oracle

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) Received on Wed Jan 21 1998 - 00:00:00 CST