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 f0PNkBq35055 for ; Thu, 25 Jan 2001 18:46:12 -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 MAA10376 for ; Fri, 26 Jan 2001 12:46:00 +1300 Message-ID: <00d401c08729$077cc440$0101a8c0@godzone.net.nz> From: "Glen and Rosanne Eustace" To: References: <00ff01c0863e$c4ef8620$0101a8c0@godzone.net.nz> <20010124125552.D17481@thune.yy.com> <003f01c08673$75d617e0$0101a8c0@godzone.net.nz> <20010124181731.G17481@thune.yy.com> Subject: Re: Problem with Dates Date: Fri, 26 Jan 2001 12:46:21 +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/372 X-Sequence-Number: 1045 template1=# select '31/12/2000'::date; ?column? ------------ 2000-12-31 (1 row) template1=# select '31/12/2000'::date + '365 days'::timespan; ?column? ------------------------ 2002-01-01 00:00:00+13 <<<<<<<<<<< Wrong (1 row) template1=# select '31/12/2000'::date + '364 days'::timespan; ?column? ------------------------ 2001-12-31 00:00:00+13 (1 row) template1=# select '31/12/2000'::date + '363 days'::timespan; ?column? ------------------------ 2001-12-30 00:00:00+13 (1 row) > Not sure if gets you anywhere. But data points. > > There is an email archive on the postgresql.org website you could search if > you think it's been answered before. I have tried looking here but it is pretty hard to know what to look for. Glen.