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 f0OJnQq61017 for ; Wed, 24 Jan 2001 14:49:26 -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 IAA07650 for ; Thu, 25 Jan 2001 08:49:14 +1300 Message-ID: <00ff01c0863e$c4ef8620$0101a8c0@godzone.net.nz> From: "Glen and Rosanne Eustace" To: Subject: Problem with Dates Date: Thu, 25 Jan 2001 08:49:27 +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/336 X-Sequence-Number: 1009 I am using 7.0.3, I have a column tstamp defined to be 'date'; With a current value of '31-12-2000', if I update tstamp=tstamp+'1 year'::timespan I get '1-1-2002' Is this what is supposed to occur. If this isn't the right way to do this, how should it be done ? Thanks -- Glen and Rosanne Eustace, GodZone Internet Services, a division of AGRE Enterprises Ltd., P.O. Box 8020, Palmerston North, New Zealand Ph: +64 6 357 8168, Mobile: +64 21 424 015