[SQL] interval as hours or minutes ?

[Aarni Ruuhimäki]

Hi all,

Could anyone please tell an easy way to get total hours or minutes from an 
interval ?

SELECT SUM(stop_date_time - start_date_time) AS tot_time FROM work_times WHERE 
user_id = 1;
    tot_time
-----------------
 2 days 14:08:44

I'd like to have this like ... AS tot_hours ...
    tot_hours
-----------------
62

and ... AS tot_minutes ...
    tot_minutes
-----------------
3728

Maybe even ... AS tot_hours_minutes_seconds
    tot_hours_minutes_seconds
-----------------
62:08:44


start_date_time and stop_date_time are stored as timestamp without time zone, 
using Pg 8.1.5 on CentOs 4.4

???

Thanks,

-- 
Aarni Ruuhimäki


---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings