Re: format difference of dates as date

"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