On Jan 13, 2011, at 9:34 AM, Allen Chen wrote: > 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.
I have the same issue on 8.4. Fixing it is low on my task list, but I too would like to know why. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
