Re: Use of SYSDATE for millisecond timing.

From: Dave Haas <davehaas_at_hotmail.com>
Date: Thu, 21 Dec 2000 17:49:34 -0700
Message-ID: <91u8mp$81u$1@news3.cadvision.com>

Good point.

Dave

"John Alexander" <jalexander_at_summitsoftwaredesign.com> wrote in message news:Qxx06.87374$58.11396414_at_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:49:34 CST