From: Cliff Crawford <cjc26@cornell.edu>
To: Ligia Pimentel <lmpimentel@yahoo.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Dateadd
Date: Fri, 4 May 2001 17:58:16 -0400
Message-ID: <20010504175816.A14070@cornell.edu> (raw)
In-Reply-To: <9cqdur$m1u$1@news.tht.net>
References: <9cqdur$m1u$1@news.tht.net>
* Ligia Pimentel <lmpimentel@yahoo.com> menulis:
> I need to know if there is a sql function implemented in postgres that gives
> me a date plus any number of days, months or years (the traditional dateadd
> function) or how to do it in sql?
cepat=# select '01-01-00'::date + '2 months 10 days'::interval;
?column?
------------------------
2000-03-11 00:00:00-05
(1 row)
--
Cliff Crawford http://www.sowrong.org/
birthday party cheesecake jellybean BOOM
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: cjc26@cornell.edu, lmpimentel@yahoo.com
Subject: Re: Dateadd
In-Reply-To: <20010504175816.A14070@cornell.edu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox