Arithmetic operation on DATE

From: "macky" <macky(at)edsamail(dot)com>
To: <pgsql-sql(at)postgresql(dot)org>, <pgsql-novice(at)postgresql(dot)org>
Subject: Arithmetic operation on DATE
Date: 2001-08-13 09:38:37
Message-ID: 008301c123db$ba9791f0$5764a8c0@edsamail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice pgsql-sql

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.
----------------------------------------------------------------------

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message macky 2001-08-13 09:48:57 Arithmetic operation on DATE
Previous Message Paul McGarry 2001-08-12 22:49:01 Re: Text Search

Browse pgsql-sql by date

  From Date Subject
Next Message macky 2001-08-13 09:48:57 Arithmetic operation on DATE
Previous Message Josh Berkus 2001-08-13 02:06:20 Re: REFERENCES constraint