interval is ignored

From: rodeored <info1(at)reenie(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: interval is ignored
Date: 2009-06-11 14:14:01
Message-ID: b56ded5d-11e9-47d3-9194-3df7f805d215@x6g2000vbg.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

SELECT INTERVAL '1' MONTH = 00:00:00
Therefore now=onemonthago
SELECT NOW(),NOW()- INTERVAL '1' MONTH as onemonthago

How do I get the timestamp for one month ago?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andy Colson 2009-06-11 14:14:36 Re: Libpq on windows
Previous Message Phil Longstaff 2009-06-11 14:11:31 Re: Libpq on windows