Re: format difference of dates as date

Rauf Sarwar wrote:
> You would have to do this in a PLSQL function that takes end_date and
> start_date and returns varchar2 as 'DD HH24:MI:SS'.
>
> Hint: (end_date - start_date) * 86400 will give you date difference in
> seconds. 86400 are number of seconds in a 24 hour period. Now you can
> do the math.

Isn't there a way to cast a number to a date and then use the regular to_char function?
Can't I add the difference of start- and endtime to some kind of "zero" date?

Cheers,
Tobi Received on Tue Apr 05 2005 - 07:44:12 CDT