Re: Re: Problem with Dates

"Glen and Rosanne Eustace" <agree(at)godzone(dot)net(dot)nz> writes:
> If some one else is running 7.1 already and can just change their
> timezone to New Zealand DT and report the results it would be great.

Well, with TZ set to NZST-12NZDT I get

regression=# select '31/12/2000'::date::timestamp;
?column?
------------------------
2000-12-31 00:00:00+13
(1 row)

regression=# select '31/12/2000'::date + '365 days'::timespan;
?column?
------------------------
2001-12-31 00:00:00+13
(1 row)

This looks promising but I wouldn't call it conclusive, particularly
since you're probably using a different OS than I am (I'm on HPUX
10.20). It would be good to bang on it some more with NZ daylight
times --- as Christopher says, GMT+13 is a tad unusual.

regards, tom lane