Re: consistant output for type interval
| От | Dorin Grunberg |
|---|---|
| Тема | Re: consistant output for type interval |
| Дата | |
| Msg-id | 4.3.2.7.2.20010716114350.00b49c40@pophost обсуждение исходный текст |
| Ответ на | consistant output for type interval (Dorin Grunberg <dorin@visgen.com>) |
| Список | 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:
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
В списке pgsql-novice по дате отправления: