Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: format difference of dates as date
Frank van Bortel wrote:
> Huh? Like the difference between April 1 and March 12 is January 31?
> I miss your question, or it is nonsense. It does not make sense
> to me anyway.
Sorry, if I did not express myself clearly.
Example:
starttime = '2005-04-01 1:30:05'
endtime = '2005-04-03 12:45:15'
wanted result = '2 11:15:10'
-- Tobias WagnerReceived on Tue Apr 05 2005 - 05:27:27 CDT