interval as hours or minutes ? - Mailing list pgsql-sql

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