Re: format difference of dates as date

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