Re: format difference of dates as date

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

You'll have to separate out the number of whole days, then you can express the time difference as a time.

datediff := ABS(date_1 - date_2)
wholedays := floor(datediff);
varchar_diff := wholedays || ' '||

   to_char(trunc(sysdate)+(datediff - wholedays),'HH24:MI:SS');

Ken Denny Received on Tue Apr 05 2005 - 10:00:34 CDT