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 -> Time diff

Time diff

From: Eugene <epipko_at_hotmail.com>
Date: 3 May 2005 09:00:59 -0700
Message-ID: <1115136059.622023.101850@o13g2000cwo.googlegroups.com> 





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
Received on Tue May 03 2005 - 11:00:59 CDT












Original text of this message













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