Postgres Pro
Downloads
Home   >   mailing lists

Re: consistant output for type interval - Mailing list pgsql-novice

From Dorin Grunberg
Subject Re: consistant output for type interval
Date
Msg-id 4.3.2.7.2.20010716114350.00b49c40@pophost
Whole thread Raw
In response to consistant output for type interval  (Dorin Grunberg <dorin@visgen.com>)
List pgsql-novice
Tree view
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

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: GROUP BY and aggregate functions
Next
From: Jeroen Heijmans
Date:
Subject: Table type attributes