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

Re: format difference of dates as date

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Tue, 5 Apr 2005 18:26:36 +0200
Message-ID: <4252c03f$0$731$626a14ce@news.free.fr>

"Tobias Wagner" <none_at_rz.uni-karlsruhe.de> a écrit dans le message de news:d2tp56$9dn$1_at_news2.rz.uni-karlsruhe.de...
| 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 Wagner
|
|

Have a look at NUMTODSINTERVAL function:

http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96540/functions86a.htm#1001049

Regards
Michel Cadot Received on Tue Apr 05 2005 - 11:26:36 CDT

Original text of this message

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