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 f0QIIhq31645 for ; Fri, 26 Jan 2001 13:18:43 -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 HAA11604; Sat, 27 Jan 2001 07:18:26 +1300 Message-ID: <013801c087c4$72309460$0101a8c0@godzone.net.nz> From: "Glen and Rosanne Eustace" To: "Tom Lane" Cc: "Christopher Sawtell" , References: <00ff01c0863e$c4ef8620$0101a8c0@godzone.net.nz> <20010124181731.G17481@thune.yy.com> <00d401c08729$077cc440$0101a8c0@godzone.net.nz> <01012621220800.13520@berty> <29575.980521515@sss.pgh.pa.us> <012701c087bf$a2ae2940$0101a8c0@godzone.net.nz> <3075.980532017@sss.pgh.pa.us> Subject: Re: Re: Problem with Dates Date: Sat, 27 Jan 2001 07:18:51 +1300 Organization: AGRE Enterprises Ltd MIME-Version: 1.0 Content-Type: text/plain; charset="Windows-1252" 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/390 X-Sequence-Number: 1063 > 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. Is 7.0.3 to 7.1B? simply a reinstall or do I need to unload/reload the database. PS: GMT+13 isn't unusual for us Kiwis, that's how its always been since some twit decided daylight saving was a good idea. The jury is still out on this one. Glen.