Intervals

From: Jake Stride <nsuk(at)users(dot)sourceforge(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Intervals
Date: 2005-04-26 09:47:08
Message-ID: 426E0E1C.90401@users.sourceforge.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Is there a way to convert in interval into hours? I have a table that
records the amount of time worked by a person and want to sum up all the
hours, however with the column being an interval once you reach more
than 24 hours it turns that into a day. This is not what I want so
instead of outputting 1day 2:00:00 I would want to output 26:00:00 is
this possible?

Thanks

Jake

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Clifton Zama 2005-04-26 10:09:22 Re: SQLException "Connection is closed. Operation is not
Previous Message Hubert Fröhlich 2005-04-26 09:24:31 oid wraparound