Skip site navigation (1) Skip section navigation (2)

Arithmetic operation on DATE

From: "macky" <macky(at)edsamail(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>, <pgsql-sql(at)postgresql(dot)org>
Subject: Arithmetic operation on DATE
Date: 2001-08-13 09:48:57
Message-ID: 001401c123dd$2c383430$5764a8c0@edsamail.com (view raw or flat)
Thread:
Lists: pgsql-novicepgsql-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

pgsql-novice by date

Next:From: Christopher SawtellDate: 2001-08-13 10:01:59
Subject: Re: [SQL] Arithmetic operation on DATE
Previous:From: mackyDate: 2001-08-13 09:38:37
Subject: Arithmetic operation on DATE

pgsql-sql by date

Next:From: Christopher SawtellDate: 2001-08-13 10:01:59
Subject: Re: [SQL] Arithmetic operation on DATE
Previous:From: mackyDate: 2001-08-13 09:38:37
Subject: Arithmetic operation on DATE

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group