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 -> format difference of dates as date

format difference of dates as date

From: Tobias Wagner <none_at_rz.uni-karlsruhe.de>
Date: Tue, 5 Apr 2005 11:30:45 +0200
Message-ID: <d2tlqn$78i$1@news2.rz.uni-karlsruhe.de> 





The difference of two dates is a number. How can I format this difference as 
a date?



What I want is



to_char(endtime-starttime, 'DD HH24:MI:SS')



but the problem is, that endtime-startime is a number and so the format 
string does not match the type of the first argument.



Any ideas?


-- 
Tobias Wagner 


Received on Tue Apr 05 2005 - 04:30:45 CDT












Original text of this message













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