Postgres Pro
Downloads
Home   >   mailing lists

Thread: consistant output for type interval

consistant output for type interval

From
Dorin Grunberg
Date:
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

Re: consistant output for type interval

From
Dorin Grunberg
Date:
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