Received: from ns1.gremlins.com.hk (ns1.gremlins.com.hk [152.101.50.194]) by postgresql.org (8.11.3/8.11.4) with SMTP id f7DA2qP88835 for ; Mon, 13 Aug 2001 06:02:53 -0400 (EDT) (envelope-from postgresql@gremlins.com.hk) Received: (qmail 905 invoked from network); 13 Aug 2001 10:00:32 -0000 Received: from unknown (HELO mojo) (10.0.0.4) by mail.gremlins.com.hk with SMTP; 13 Aug 2001 10:00:32 -0000 Message-ID: <00be01c123df$1365c380$0400000a@gremlins.com.hk> From: "Jason Wong" To: "macky" , , References: <001401c123dd$2c383430$5764a8c0@edsamail.com> Subject: Re: Arithmetic operation on DATE Date: Mon, 13 Aug 2001 18:02:34 +0800 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.00.2615.200 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200 X-Archive-Number: 200108/45 X-Sequence-Number: 1851 I know you can do it for days, thus: expires = CURRENT_TIMESTAMP + 10 would be 10 days from now. Don't know about months though. HTH -- Jason Wong Gremlins Associates www.gremlins.com.hk ----- Original Message ----- From: macky To: ; Sent: Monday, August 13, 2001 5:48 PM Subject: [NOVICE] Arithmetic operation on DATE > is it possible to add a date datatype column to a number resulting to a > date...... > > > theoretically it should do this,,, > > X is in months > > date + X = date > > --> 2001-08-20 + 6 = 2002-02-20 >