Re: [GENERAL] Inconsistent time interval formatting

2011-01-13 Thread Allen Chen
> > That won't really help. The fundamental point here is that '1 day' is > not the same concept as '24 hours', because of DST changes; and the > interval type treats them as different. > > If you don't care about that, you can use justify_hours (I think that's > the right function) to smash them

[GENERAL] Inconsistent time interval formatting

2011-01-13 Thread Allen Chen
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 wherea