Received: from agree-6.godzone.net.nz (adsl-123.win.co.nz [203.96.91.123]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f0P26jq96895 for ; Wed, 24 Jan 2001 21:06:45 -0500 (EST) (envelope-from agree@godzone.net.nz) Received: from agree1.godzone.net.nz (agree-1 [192.168.1.1]) by agree-6.godzone.net.nz (8.9.3/8.9.3) with SMTP id PAA08037; Thu, 25 Jan 2001 15:06:23 +1300 Message-ID: <003f01c08673$75d617e0$0101a8c0@godzone.net.nz> From: "Glen and Rosanne Eustace" To: "Mike Castle" , References: <00ff01c0863e$c4ef8620$0101a8c0@godzone.net.nz> <20010124125552.D17481@thune.yy.com> Subject: Re: Problem with Dates Date: Thu, 25 Jan 2001 15:06:38 +1300 Organization: AGRE Enterprises Ltd MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4522.1200 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200 X-Archive-Number: 200101/344 X-Sequence-Number: 1017 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.