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 f0QHiOq28108 for ; Fri, 26 Jan 2001 12:44:24 -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 GAA11555; Sat, 27 Jan 2001 06:44:00 +1300 Message-ID: <012701c087bf$a2ae2940$0101a8c0@godzone.net.nz> From: "Glen and Rosanne Eustace" To: "Christopher Sawtell" , "Tom Lane" Cc: 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> Subject: Re: Re: Problem with Dates Date: Sat, 27 Jan 2001 06:44:26 +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/387 X-Sequence-Number: 1060 > Could one of you try it in 7.1 (beta3 or later)? We've changed some > details of the way daylight-savings transitions are handled in > date-to-timestamp conversions, so I think this might be fixed now. > It's worth checking anyway. I would prefer not to upgrade right at the moment, as my development system is in the middle of a migration exercise ( hence the discovery of this bug ). 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. > Also, what do you get from '31/12/2000'::date::timestamp? template1=# select '31/12/2000'::date::timestamp template1-# ; ?column? ------------------------ 2001-01-01 00:00:00+13 (1 row) template1=#