Re: Dates in postgres - Mailing list pgsql-novice

From Anton de Wet
Subject Re: Dates in postgres
Date
Msg-id Pine.LNX.4.33.0202251800070.19276-100000@localhost.localdomain
Whole thread Raw
In response to Dates in postgres  (Rob <rob@obsidian.co.za>)
List pgsql-novice
On Mon, 25 Feb 2002, Rob wrote:

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

select now() - interval '1 month';


--

----------------------------------------------------------------------
"I really didn't foresee the Internet. But then, neither did the computer
industry. Not that that tells us very much of course - the computer industry
didn't even foresee that the century was going to end."
   - Douglas Adams


pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: Can't use PGAccess with KDE 2.2
Next
From: "cristi"
Date:
Subject: update