Re: Dateadd - Mailing list pgsql-sql

From Cliff Crawford
Subject Re: Dateadd
Date
Msg-id 20010504175816.A14070@cornell.edu
Whole thread Raw
In response to Dateadd  ("Ligia Pimentel" <lmpimentel@yahoo.com>)
Responses Re: Dateadd  ("Josh Berkus" <josh@agliodbs.com>)
List pgsql-sql
* 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


pgsql-sql by date:

Previous
From: Martín Marqués
Date:
Subject: Re: create table
Next
From: Christopher Sawtell
Date:
Subject: Re: '13 months ago'::reltime