Re: Dates in postgres

On Mon, 25 Feb 2002, Rob wrote:

> 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?

select now() - interval '1 month';


-- 

----------------------------------------------------------------------
"I really didn't foresee the Internet. But then, neither did the computer
industry. Not that that tells us very much of course - the computer industry
didn't even foresee that the century was going to end."
   - Douglas Adams