Date Calculation

From: john bruin <jbruin_at_tssc.co.nz>
Date: Mon, 26 Apr 1999 10:55:05 +1200
Message-ID: <37239D2C.5444@tssc.co.nz>

Hi all

I would like to know if it is possible to have a column showing the time difference between two time columns. It seems to work with a non-hours,min date format but otherwise not. Can anyone help here?

ie Occurred           Fixed               Repair Time
   4-feb-99 3:00 PM  10-feb-99 4:00 PM     6 DAYS 1 HOUR

select
to_char(date_occurred,'dd-mon-yy HH:MI PM') Occurred
,to_char(date_fixed,'dd-mon-yy HH:MI PM') Fixed
,something like - date_fixed - date_occurred 'Repair Time'

Regards
John Received on Sun Apr 25 1999 - 17:55:05 CDT