Sum of Intervals

From: Plant Thomas <Thomas(dot)Plant(at)lvh(dot)it>
To: pgsql-sql(at)postgresql(dot)org
Subject: Sum of Intervals
Date: 2003-02-12 14:37:07
Message-ID: 418DEFFAA399D311818A00508B912F2883D74A@idefix.lvh.dnet.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hello,

I'm trying to do a sum() of some time intervals.
I get the result as: '1 day 02:30' which is ok, but is there a function
which converts this to hours or do I have to write my own?
For example the '1 day 02:30' should become 26:30 hours.

Thanks for any advice,
Thomas

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Jr. 2003-02-12 14:59:58 Re: PL/Pgsql trigger function problem.
Previous Message Christoph Haller 2003-02-12 14:18:38 Re: Problems with Transactions