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 flat)
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

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-2014 The PostgreSQL Global Development Group