Postgres Pro
Downloads
Home   >   mailing lists

Dates in postgres - Mailing list pgsql-novice

From Rob
Subject Dates in postgres
Date
Msg-id Pine.LNX.4.33L2.0202251501400.25704-100000@Genesis
Whole thread Raw
Responses Re: Dates in postgres
Re: Dates in postgres
List pgsql-novice
Tree view 
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

pgsql-novice by date:

Previous
From: otisg@ivillage.com
Date:
Subject: plpgsql: eeturning resultset from func.?
Next
From: Jim Lanford
Date:
Subject: help installing psql 7.1.3 - rh6.2 - libreadline.so.4