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
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 |