interval as hours or minutes ?

From: Aarni Ruuhimäki <aarni(at)kymi(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: interval as hours or minutes ?
Date: 2007-02-07 17:03:35
Message-ID: 200702071903.35126.aarni@kymi.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Bricklen Anderson 2007-02-07 17:33:40 Re: interval as hours or minutes ?
Previous Message Thomas Kellerer 2007-02-06 23:15:18 Re: Removing duplicate rows