Arithmetic operation on DATE - Mailing list pgsql-sql

From macky
Subject Arithmetic operation on DATE
Date
Msg-id 008301c123db$ba9791f0$5764a8c0@edsamail.com
Whole thread Raw
Responses Re: Arithmetic operation on DATE  (Antti Linno <alligator@all.ee>)
Re: Arithmetic operation on DATE  (Christopher Sawtell <csawtell@paradise.net.nz>)
List 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.
----------------------------------------------------------------------



pgsql-sql by date:

Previous
From: "Josh Berkus"
Date:
Subject: Re: REFERENCES constraint
Next
From: "macky"
Date:
Subject: Arithmetic operation on DATE