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: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Tue, 05 Apr 2005 12:18:00 +0200
Message-ID: <d2toei$mvb$1@news4.zwoll1.ov.home.nl>


Tobias Wagner wrote:
> 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?
>

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.

-- 
Regards,
Frank van Bortel
Received on Tue Apr 05 2005 - 05:18:00 CDT

Original text of this message

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