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, whole thread or download thread mbox)
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-2017 The PostgreSQL Global Development Group