Re: How to calculate difference in time?

>>All I want is the difference in time (possibly to the micro second).
>>Is there any way to do it? Thank you.

dbms_utility.get_time returns the time in 100th's of a second, starting some arbitrary moment in the past. So, you can not use it to calculate the actual system date in 100th's of a second, but you may indeed use it to get the time difference between two moments.

    function get_time return number;

Arjan. Received on Mon Sep 21 1998 - 12:54:44 CDT