Re: Comparing Dates

 It's the number of days between date1 and date2. The query

select to_date('27-may-99 12:00', 'dd-mon-yy hh24:mi') - to_date('25-may-99')
from dual;

you will get 2.5 (noon on the 27th - midnight on the 25th).

Dennis

Fred Ruffet wrote:

> I know this, but what is the unit for the result of date1-Date2 ?
>
> Fred
Received on Thu May 27 1999 - 14:05:47 CDT