Re: Dates in postgres

From: "Josh Berkus" <josh(at)agliodbs(dot)com>
To: Rob <rob(at)obsidian(dot)co(dot)za>, PostgreSQL Server <postgres(at)obsidian(dot)co(dot)za>, <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Dates in postgres
Date: 2002-02-25 17:16:34
Message-ID: web-800782@davinci.ethosmedia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Rob,

> I can get today's date in postgres using the current_date function,
> but I
> need to get the date one month ago from the current date. Is there
> any
> way to do this?

See:
http://techdocs.postgresql.org/techdocs/faqdatesintervals.php

-Josh

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2002-02-25 17:38:43 Re: Array as a parameter in user-defined functions
Previous Message David J. Lines 2002-02-25 16:38:30 Major newbie