Re: Use of SYSDATE for millisecond timing.

From: John Alexander <jalexander_at_summitsoftwaredesign.com>
Date: Fri, 22 Dec 2000 00:48:48 GMT
Message-ID: <Qxx06.87374$58.11396414@typhoon.tampabay.rr.com>

While the date function does not include milliseconds, you can determine elapsed time using the function dbms_utility.get_time. It gives you hundreths of a second.

Dave Haas <davehaas_at_hotmail.com> wrote in message news:91u7bd$7b2$1_at_news3.cadvision.com...
> Nope. Since the Oracle DATE datatype only records down to the second,
> that's all you get with sysdate. You either need to go Java (if 8i) or
> external.
>
> Dave
>
>
> <jsicore_at_my-deja.com> wrote in message news:91u311$10u$1_at_nnrp1.deja.com...
> > Is there any way to improve the precision (<1 sec.) of SYSDATE?
> > I can only perform measurements on SYSDATE down to the second, anything
> > less causes rounding to the second.
> >
> > Thanks.
> >
> >
> > Sent via Deja.com
> > http://www.deja.com/
>
>
>
Received on Thu Dec 21 2000 - 18:48:48 CST