Re: Dateadd

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: Ligia Pimentel <lmpimentel(at)yahoo(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Dateadd
Date: 2001-05-04 21:34:14
Message-ID: Pine.BSF.4.21.0105041432470.61624-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

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

Browse pgsql-sql by date

  From Date Subject
Next Message Joel Burton 2001-05-04 21:38:31 Re: create table
Previous Message Martín Marqués 2001-05-04 16:17:02 Re: create table