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: Date and Time arithmetic

Re: Date and Time arithmetic

From: robertsboyle <member21885_at_dbforums.com>
Date: Wed, 12 Mar 2003 09:24:48 +0000
Message-ID: <2633096.1047461088@dbforums.com> 






Try


SELECT TRUNC(MOD((time2 - time1) * 24 * 24, 60)) || 'hrs ' ||
TRUNC(MOD((time2 - time1) * 24 * 60, 60)) || 'mins ' || TRUNC(MOD((time2
- time1) * 24 * 60 * 60, 60)) || ' seconds' from dual;



hth


R.


--
Posted via http://dbforums.com


Received on Wed Mar 12 2003 - 03:24:48 CST












Original text of this message













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