Dates in postgres

From: Rob <rob(at)obsidian(dot)co(dot)za>
To: PostgreSQL Server <postgres(at)obsidian(dot)co(dot)za>, <pgsql-novice(at)postgresql(dot)org>
Subject: Dates in postgres
Date: 2002-02-25 20:03:10
Message-ID: Pine.LNX.4.33L2.0202251501400.25704-100000@Genesis
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi,

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?

Thanks

Rob

--
He who dies with the most toys ...

... still dies

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Dave Peticolas 2002-02-26 02:34:47 A question about functions and transactions.
Previous Message Oliver Elphick 2002-02-25 19:59:56 Re: Major newbie