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: Formatting Differences in Dates

Re: Formatting Differences in Dates

From: JoeZ53 <joez53_at_aol.com>
Date: 25 Mar 1999 15:02:31 GMT
Message-ID: <19990325100231.19769.00000081@ng-ch1.aol.com> 





kinda complex but:



to_char (trunc ((end_date - start_date)*24))||' hours '||


    to_char (mod (trunc ((end_date - start_date)*1440), 1440))||' minutes '||
   to_char (mod ((end_date - start_date)*86400), 86400))||' seconds'



Personally, I'd rather use a PL/SQL function.



Joe Zafian
Received on Thu Mar 25 1999 - 09:02:31 CST












Original text of this message













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