Hi Muralees:

Try this:


select (end_date-start_date)*24 from table;

i.e


select (to_date('01-jan-02,'dd-mon-yy')-to_date('30-dec-01','dd-mon-yy'))*24 hrs from dual;

will return 48 hrs.

hth
may$e