Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Time diff

Re: Time diff

From: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Tue, 03 May 2005 19:32:49 +0200
Message-ID: <d58ccd$6fr$1@news2.zwoll1.ov.home.nl>


Eugene wrote:
> Hi all,
> I have two columns representing start_datetime and end_datetime. They
> look like 1085008980 and 1085009504 respectively. They are stored in
> UTC format (number of seconds from '15/12/1970').
> How do I calculate difference in hours:minutes:seconds?
>
> Thanks,
> Eugene
>

Are they date columns? If so (and they *should* be), simply subtract.
As they are numbers, simply subtract, and do some math, you know, like dividing through the number of seconds in a minute, in an hour, etc.

I don't know where you had the idea UTC has a format that does something magical with the year 1970. UTC is a time *zone*, not a format.
Formerly known as Greenwich time.

-- 
Regards,
Frank van Bortel
Received on Tue May 03 2005 - 12:32:49 CDT

Original text of this message

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