Re: how can I calculate the difference in time between two oracle date/times
Date: Fri, 11 Jan 2002 15:08:54 GMT
Message-ID: <aeD%7.4401$uA.39099_at_rwcrnsc51.ops.asp.att.net>
If you subtract one from the other you get days.fraction of a day. From
that you need to break down the fraction of a day into hours minutes and
seconds.
Jim
"Brian Penn" <ecl6bp_at_leeds.ac.uk> wrote in message
news:f58eff45.0201110315.782610bc_at_posting.google.com...
> Hello,
>
> I have been trying to calculate the difference in time between two
> date/times i.e starttime & endtime
>
> I want to end up with out put in hours and minutes and seconds.
>
>
> I have tried endtime - starttime for day count and have tried using
> julian dates * seconds.
>
> what I need to do is i.e :: calculate difference between 18-SEP-01:
> 11:10:00 and 20-SEP-01 :23:44:00
>
> and get total hous minutes and seconds as the result i.e 60 hrs 34
> minutes 00 seconds
>
>
> any help would be great
>
>
> Brian Pen
Received on Fri Jan 11 2002 - 16:08:54 CET