Received: from despair.sowrong.org (syr-24-24-23-149.twcny.rr.com
	[24.24.23.149])
	by postgresql.org (8.11.3/8.11.1) with ESMTP id f44LuuA74254
	for <pgsql-sql@postgresql.org>; Fri, 4 May 2001 17:56:56 -0400 (EDT)
	(envelope-from cjc26@despair.sowrong.org)
Received: (from cjc26@localhost)
	by despair.sowrong.org (8.11.0/8.11.0) id f44LwGC14078;
	Fri, 4 May 2001 17:58:16 -0400 (EDT)
Date: Fri, 4 May 2001 17:58:16 -0400
From: Cliff Crawford <cjc26@cornell.edu>
To: Ligia Pimentel <lmpimentel@yahoo.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: Dateadd
Message-ID: <20010504175816.A14070@cornell.edu>
References: <9cqdur$m1u$1@news.tht.net>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
User-Agent: Mutt/1.2.5i
In-Reply-To: <9cqdur$m1u$1@news.tht.net>;
	from lmpimentel@yahoo.com on Wed, May 02, 2001 at 07:55:39PM -0500
X-Archive-Number: 200105/31
X-Sequence-Number: 2832

* 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