Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: dbms_utility.get_time returns negative number
John -
It should be alright. Assuming that you checked out the Oracle
documentation
pertaining to this function, you'll know that the get_time function
measures
time from some arbitrary point. This function is normally called twice
to
measure the time passage of stuff in between those calls.
For an example of how this function can be used, see a snippet
of Tom Kyte's column "Java Tips, JDBC,
PL/SQL Stored Procedures, and Custom Prompts" at
http://www.oracle.com/oramag/oracle/00-nov/index.html?o60tom.html.
Look near the bottom.
Tom
John Dunn wrote:
> Is is correct that dbms_utility.get_time returns a negative number?
>
> I want to get the time in hundredths of a second.
>
> SQLWKS> declare l_time number;
> 2> begin l_time := dbms_utility.get_time;
> 3> dbms_output.put_line(to_char(l_time));
> 4> end;
> 5>
> 6>
> 7>
> Statement processed.
> -223020877
Received on Mon Aug 05 2002 - 11:31:56 CDT