Date Comparisons

From: Ron Joffe <rjoffe_at_er4.eng.ohio-state.edu>
Date: 1997/08/29
Message-ID: <5u71pb$skt$1@charm.magnus.acs.ohio-state.edu>#1/1

I am trying to compare the system date (sysdate) and other date field (old_date).

If I do a :
SQL> SELECT sysdate - old_date from table; I get a Julian Date back: something like : 2.345345
I would like to convert that to an hour minute sec type format.

I tried to use the TO_DATE and TO_CHAR using the julian date operator, but it only handles full days, and does not process the devmal part of the day.

Any help would be appreciated.

Thanks,

Ron Received on Fri Aug 29 1997 - 00:00:00 CDT