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: How to calculate difference in time?

Re: How to calculate difference in time?

From: <cdoganay_at_my-dejanews.com>
Date: Mon, 21 Sep 1998 21:53:04 GMT
Message-ID: <6u6hs0$t4u$1@nnrp1.dejanews.com>


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

Original text of this message

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