Received: from mail01.edsamail.com.ph (mail01.edsamail.com.ph [210.16.71.2]) by postgresql.org (8.11.3/8.11.4) with SMTP id f7D9pwP85259 for ; Mon, 13 Aug 2001 05:51:59 -0400 (EDT) (envelope-from macky@edsamail.com) Received: (qmail 405 invoked from network); 13 Aug 2001 09:51:49 -0000 Received: from unknown (HELO antivirus.edsamail.com) (210.16.70.21) by mail01.edsamail.com.ph with SMTP; 13 Aug 2001 09:51:49 -0000 Received: (qmail 4823 invoked from network); 13 Aug 2001 08:26:28 -0000 Received: from unknown (HELO gatekeeper.edsamail.com) (210.16.70.21) by 210.16.70.21 with SMTP; 13 Aug 2001 08:26:28 -0000 Received: from macky (internal-87 [192.168.100.87]) by gatekeeper.edsamail.com (8.9.3/8.9.3) with SMTP id RAA13199; Mon, 13 Aug 2001 17:51:49 +0800 Message-ID: <001401c123dd$2c383430$5764a8c0@edsamail.com> From: "macky" To: , Subject: Arithmetic operation on DATE Date: Mon, 13 Aug 2001 17:48:57 +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.50.4522.1200 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200 X-Archive-Number: 200108/44 X-Sequence-Number: 1850 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 ---------------------------------------------------------------------- The information contained in this message (including any attachments) is confidential and intended solely for the attention and use of the named addressee(s). It must not be copied, distributed nor disclosed to any person. If you are not the intended recipient, please delete it from your system and notify sender immediately. Any disclosure, copying or distribution thereof or any action taken or omitted to be taken in reliance thereon is prohibited and may be unlawful. ----------------------------------------------------------------------