Re: Date Calculation

From: Oracle NetNews <joey.ogalesco_at_bigfoot.com>
Date: Sun, 25 Apr 1999 21:40:53 -0400
Message-ID: <7g1nrh$11r$1@bgtnsc03.worldnet.att.net>

John,

Try this ..

Select to_char(date_fixed - date_occurred,"dd-mon-yy hh24:mi") "Repair Time"

john bruin wrote in message <37239D2C.5444_at_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 - 20:40:53 CDT