Re: Dateadd

From: Cliff Crawford <cjc26(at)cornell(dot)edu>
To: Ligia Pimentel <lmpimentel(at)yahoo(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Dateadd
Date: 2001-05-04 21:58:16
Message-ID: 20010504175816.A14070@cornell.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

* Ligia Pimentel <lmpimentel(at)yahoo(dot)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

In response to

  • Dateadd at 2001-05-03 00:55:39 from Ligia Pimentel

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Stephan Szabo 2001-05-04 22:06:24 Re: delete with cascade
Previous Message Joel Burton 2001-05-04 21:38:31 Re: create table