Re: consistant output for type interval

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