Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Geting Time in milliseconds

Re: Geting Time in milliseconds

From: Andreas Stephan <andreas.stephan.as_at_bayer-ag.de>
Date: Fri, 21 Sep 2001 11:45:08 +0200
Message-ID: <9of274$sbj8@byz672.bayer-ag.com>


Hi Tigran,

try using DBMS_UTILITY.GET_TIME;

but be aware it only privedes 100ths of seconds. Milliseconds are not possible.

hth
Andy

Tigran Sardaryan <spider_at_zvartnots.am> schrieb in im Newsbeitrag: b271c2ce.0109200509.74d8a0b0_at_posting.google.com...
> Hello :)
>
> I have 2 procedures like this
>
> procedure p1 is
> begin ... end;
>
> procedure p2 is
> begin
> p1;
> end;
>
> I want to get p1 procedure running time in p2 in milliseconds
> and post it to output.
>
> How I can do that ?
>
> Thanks
Received on Fri Sep 21 2001 - 04:45:08 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US