Re: More straight forward method to convert seconds::bigint to interval

From: Shane Spencer <shane(at)bogomip(dot)com>
To: Adam Rich <adam(dot)r(at)sbcglobal(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: More straight forward method to convert seconds::bigint to interval
Date: 2009-09-23 21:41:34
Message-ID: b19ddd5a0909231441y3295fa95rfd57a876924d37c1@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Well worth joining the list. Thanks guys.

On Wed, Sep 23, 2009 at 12:48 PM, Adam Rich <adam(dot)r(at)sbcglobal(dot)net> wrote:
> Shane R. Spencer wrote:
>>
>> I work in VoIP.  HMS (Hour/Minute/Second) format appears to be the rule
>> when working with call time totals.  I admit it makes some reports
>> easier to read.
>>
>> The method I used to convert a int/bigint to HMS (or the standard
>> representation of an interval type) is as follows:
>>
>> select (123456.789::varchar(24) || ' seconds')::interval as HMS;
>>     hms
>> --------------
>>  34:17:36.789
>>
>> Is there a less string oriented method of converting seconds as an int
>> to an interval?
>>
>> - Shane
>>
>
> I think this is cleaner/faster:
>
>
> select interval '1 second' * 123456.789 as HMS;
>
>     hms
> --------------
>  34:17:36.789
>
>
> -Adam
>
>
>
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Greg Smith 2009-09-23 21:54:04 Re: How to get variable out to shell script
Previous Message Tom Lane 2009-09-23 21:30:03 Re: Possible Bug - error creating a tablespace