Horton

Re: Problem with Dates

Glen and Rosanne Eustace <agree@godzone.net.nz>

View thread View on postgr.es
From: "Glen and Rosanne Eustace" <agree@godzone.net.nz>
To: "Mike Castle" <dalgoda@ix.netcom.com>, <pgsql-sql@postgresql.org>
Date: 2001-01-25T02:06:38Z
Lists: pgsql-sql 
pressie# select '31/12/2000'::date + '1 year'::timespan;
          ?column?
-----------------------------
 01/01/2002 00:00:00.00 NZDT
(1 row)

pressie=#

Well I do :-(

I vaguely remember someone else having the same problem and it was
something to do with daylight saving.  I don't recall the solution
though, if there was one.

Glen.