Re: Regarding interval conversion functions and a seeming lack of usefulness

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bill Moran <wmoran(at)collaborativefusion(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Regarding interval conversion functions and a seeming lack of usefulness
Date: 2008-02-27 15:40:09
Message-ID: 28635.1204126809@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Bill Moran <wmoran(at)collaborativefusion(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message paul rivers 2008-02-27 15:47:31 Re: Query meltdown: caching results
Previous Message Magnus Hagander 2008-02-27 15:13:49 Re: win32: how to backup (dump does not work)