Received: from postgresql.org.org (webmail.postgresql.org [216.126.85.28]) by postgresql.org (8.11.3/8.11.4) with SMTP id f7EGa2P77280 for ; Tue, 14 Aug 2001 12:36:02 -0400 (EDT) (envelope-from pgsql-novice-owner@postgresql.org) Received: from deborah.paradise.net.nz (deborah.paradise.net.nz [203.96.152.32]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f7DA1NP88328; Mon, 13 Aug 2001 06:01:23 -0400 (EDT) (envelope-from csawtell@paradise.net.nz) Received: from there (202-0-37-152.cable.paradise.net.nz [202.0.37.152]) by deborah.paradise.net.nz (Postfix) with SMTP id 3FECD1FA04B; Mon, 13 Aug 2001 22:01:19 +1200 (NZST) Content-Type: text/plain; charset="iso-8859-1" From: Christopher Sawtell To: "macky" , , Subject: Re: [SQL] Arithmetic operation on DATE Date: Mon, 13 Aug 2001 22:01:59 +1200 X-Mailer: KMail [version 1.2.3] References: <001401c123dd$2c383430$5764a8c0@edsamail.com> In-Reply-To: <001401c123dd$2c383430$5764a8c0@edsamail.com> MIME-Version: 1.0 Content-Transfer-Encoding: 8bit Message-Id: <20010813100119.3FECD1FA04B@deborah.paradise.net.nz> X-Archive-Number: 200108/58 X-Sequence-Number: 1866 On Mon, 13 Aug 2001 21:48, macky wrote: > is it possible to add a date datatype column to a number resulting to a > date...... chris=# select date(CURRENT_TIMESTAMP); date ------------ 2001-08-13 (1 row) chris=# select date(CURRENT_TIMESTAMP) + '6 @days'::interval; ?column? ------------------------ 2001-08-19 00:00:00+12 (1 row) chris=# select date(date(CURRENT_TIMESTAMP) + '6 @days'::interval); date ------------ 2001-08-19 (1 row) That what you want? > 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. > ---------------------------------------------------------------------- > > > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster