Re: elapsed time in millisecond

TurkBear wrote:
>
> Is that a problem?
> ...the math to convert is not complicated - multiply by 10 for milliseconds
> :-)
>
> Connor McDonald <connor_mcdonald_at_yahoo.com> wrote:
>
> >DanHW wrote:
> >>
> >> >How can I get the elasped time in millisecond between start and end time
> >> >interva
> >> >l ?
> >>
> >> Use the DBMS_UTILITY.GETTIME function. Returns the time since (?) in
> >> milliseconds. Store the start time, and call it again to get the ending time
> >> for the operation.
> >
> >Unfortunately this is 100th's not 1000th's of a second...
> >
> >Cheers
>
> -----------== Posted via Newsfeeds.Com, Uncensored Usenet News ==----------
> http://www.newsfeeds.com The Largest Usenet Servers in the World!
> ------== Over 73,000 Newsgroups - Including Dedicated Binaries Servers ==-----

Yes but you don't have significant digits - thus you can only report to the nearest "centisecond". No problems for most situations I admit, but if you genuinely want milliseconds, then you're out of luck...

Cheers

-- 
===========================================
Connor McDonald
"These views mine, no-one elses etc etc"
connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue."