Skip site navigation (1) Skip section navigation (2)

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 (view raw or whole thread)
Lists: pgsql-novice

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?



He who dies with the most toys ...

					... still dies


pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group