Re: bizarre AGE behaviour

On Wednesday 03 March 2004 9:19 am, DHS Webmaster wrote:
> We began encountering some unexpected date related errors this
week...
<snip>
> This is good...
> network=# select age('04-01-04','03-01-04');
> age
> -------
> 1 mon
> (1 row)
>
> This isn't...
> network=# select age('05-01-04','03-01-04');
> age
> ---------------------
> 1 mon 30 days 23:00
> (1 row)
>
> Now it gets really strange......
> network=# select age('06-01-04','04-01-04');
> age
> ---------------------
> 1 mon 29 days 23:00
> (1 row)
>
> This may have been addressed in the past (I subscribe to this list)
> and I just missed it, but is there a simple fix for this problem?
> Thanks.

It was originally addressed long in the past (1784, Paris by Benjamin
Franklin): http://webexhibits.org/daylightsaving/

US Daylight Saving Time starts this year on April 4 when 0200 jumps to
0300. The answers PostgreSQL gave are correct.

Cheers,
Steve