Has anyone else out there noticed inconsistencies in how pgsql formats time
intervals over 1 day?
For example, I have a query that returns a column of intervals and I get
output like this:
30:30:00
1 day 03:02:47
1 day 01:38:34
26:25:29.50
Why do some of the intervals show days broken out whereas others only show
hours? I have seen intervals left in hours even when the intervals are
more than two days long. FWIW, I would prefer if it was always left in
hours, but would be happy if it would just be consistent either way.
I'm running PostgreSQL 8.3.12, but I have seen this in earlier versions I've
used too.
-Allen