Re: consistant output for type interval

From: Dorin Grunberg <dorin(at)visgen(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: consistant output for type interval
Date: 2001-07-16 15:48:33
Message-ID: 4.3.2.7.2.20010716114350.00b49c40@pophost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Sorry, I did some research and I came with this solution:

SELECT extract(day from sum(my_co))*24 + lpad(extract(hour from
sum(my_co)), 2, '0')||':'||lpad(extract(minute from sum(my_co)), 2, '0')
FROM tr;

Dorin

At 11:09 AM 7/16/01 -0400, Dorin Grunberg wrote:
>Hi,
>
>I have a table where one of the columns is of type interval.
>
>When I calculate the sum of that column the results are looking like this:
>
>1 day 5:30
>1 day
>05:45
>
>I would like to have it consistent in the HH:MM format and, if it is not
>possible this way, perhaps something like:
>
>1 day 05:30
>1 day 00:00
>0 day 05:45
>
>I know I can manipulate the results on the Perl or PHP side but I thought
>that there might be another way.
>
>Thanks,
>
>Dorin
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 4: Don't 'kill -9' the postmaster

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Henry House 2001-07-16 15:53:07 Re: GROUP BY and aggregate functions
Previous Message Dorin Grunberg 2001-07-16 15:09:35 consistant output for type interval