Re: Dateadd - Mailing list pgsql-sql

From Stephan Szabo
Subject Re: Dateadd
Date
Msg-id Pine.BSF.4.21.0105041432470.61624-100000@megazone23.bigpanda.com
Whole thread Raw
In response to Dateadd  ("Ligia Pimentel" <lmpimentel@yahoo.com>)
List pgsql-sql
On Wed, 2 May 2001, Ligia Pimentel wrote:

> 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?

Just add a date and an interval.  Something like:
date + '1 day'::interval



pgsql-sql by date:

Previous
From: LeoDeBeo
Date:
Subject: create table
Next
From: Bruce Momjian
Date:
Subject: Re: Re: Use of the LIMIT clause ?