Re: Date Comparisons

From: Mike Morgan <mmorga2_at_amfam.com>
Date: 1997/08/29
Message-ID: <01bcb4ba$2dba92d0$7c38c8a5@mxm014pc>#1/1

Ron,

When you subtract two dates, the result is given in days. So the response you get is 2.345345 days. All you need to do now is calculate how many hours/minutes/seconds .345345 days represents.

Mike Morgan

+++++++++++++++++++++++++++++++++++++++

Ron Joffe wrote in article
| 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.
|
Received on Fri Aug 29 1997 - 00:00:00 CDT