Calculating Time Difference in Oracle 1

[sitadba]

Hello All,

I'm trying to calculate the time difference between 2 datetime fields. Field 1 is open_time Field 2 is close_time, both are datetime fields.

I need to calculate the time difference between close_time and open_time in days and minutes.

If I do:

select (close_time-open_time) from dual;

I get the difference in the #of days. I need it in days and minutes.

If open_time = 1/21/2003 12:32:29 PM and
close_time = 1/23/2003 10:20:57 AM

I need the return to = 1 day, 11 hours & 28 minutes

Or I would be happy with total difference in minutes such as 2,128 minutes.

Any help would be appreciated.

Brgds,
Denise

 

[carp]

(close_time - open_time) * 1440
will give you total minutes.

Elbert, CO
1344 MST

 

[sitadba]

Thank you very much. This was exactly what I needed.

Brgds,
Denise