how can I calculate the difference in time between two oracle date/times

Hello,

I have been trying to calculate the difference in time between two date/times i.e starttime & endtime

I want to end up with out put in hours and minutes and seconds.

I have tried endtime - starttime for day count and have tried using julian dates * seconds.

what I need to do is i.e :: calculate difference between 18-SEP-01: 11:10:00 and 20-SEP-01 :23:44:00

and get total hous minutes and seconds as the result i.e 60 hrs 34 minutes 00 seconds

any help would be great

Brian Pen Received on Fri Jan 11 2002 - 12:15:51 CET