Received: from sss.pgh.pa.us (sss.pgh.pa.us [209.114.132.154]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f0QI0Xq30011 for ; Fri, 26 Jan 2001 13:00:33 -0500 (EST) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.1/8.11.1) with ESMTP id f0QI0H903078; Fri, 26 Jan 2001 13:00:17 -0500 (EST) To: "Glen and Rosanne Eustace" cc: "Christopher Sawtell" , pgsql-sql@postgresql.org Subject: Re: Re: Problem with Dates In-reply-to: <012701c087bf$a2ae2940$0101a8c0@godzone.net.nz> 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> Comments: In-reply-to "Glen and Rosanne Eustace" message dated "Sat, 27 Jan 2001 06:44:26 +1300" Date: Fri, 26 Jan 2001 13:00:17 -0500 Message-ID: <3075.980532017@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200101/388 X-Sequence-Number: 1061 "Glen and Rosanne Eustace" 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