Re: Date Arithmetic Question

> What sql can I use to tel how many hours(10,2 number) have elapsed between
> to DATE type fields

Try:

SQL> select ( sysdate - (sysdate - 5 - 3/24) ) * 24 from dual;

(SYSDATE-(SYSDATE-5-3/24))*24

                          123

Sincerely,
Maury Received on Sat Oct 23 1999 - 08:26:34 CDT