Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: How to calculate difference in time?
Another way is to use v$timer view. It is one column table and gives you hsec
in some numbers.But, you should have rights to access this view.
Cemal
In article <6u63qd$8f$1_at_pascal.a2000.nl>,
"Arjan van Bentem" <avbentem_at_DONT-YOU-DAREdds.nl> wrote:
> >>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.
>
>
-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Mon Sep 21 1998 - 16:53:04 CDT