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