Postgres Pro
Downloads
Home   >   mailing lists

Re: Regarding interval conversion functions and a seeming lack of usefulness - Mailing list pgsql-general

From Tom Lane
Subject Re: Regarding interval conversion functions and a seeming lack of usefulness
Date
Msg-id 28635.1204126809@sss.pgh.pa.us
Whole thread Raw
In response to Regarding interval conversion functions and a seeming lack of usefulness  (Bill Moran <wmoran@collaborativefusion.com>)
Responses Re: Regarding interval conversion functions and a seeming lack of usefulness
List pgsql-general
Tree view 
Bill Moran <wmoran@collaborativefusion.com> writes:
> There seems to be a lack of useful functions for converting intervals
> to useful representations.  For example, I want to display an interval
> in hours and fractions of hours only, not hours and minutes.

Perhaps EXTRACT(EPOCH ...) to get total seconds and then do some
arithmetic?

            regards, tom lane

pgsql-general by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: win32: how to backup (dump does not work)
Next
From: paul rivers
Date:
Subject: Re: Query meltdown: caching results