Re: elapsed time in millisecond
From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Wed, 17 Nov 1999 17:33:04 +0800
Message-ID: <38327650.7629_at_yahoo.com>
Date: Wed, 17 Nov 1999 17:33:04 +0800
Message-ID: <38327650.7629_at_yahoo.com>
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
-- =========================================== 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."Received on Wed Nov 17 1999 - 10:33:04 CET