Help With date/time

From: Alex <alex(at)meerkatsoft(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Help With date/time
Date: 2003-11-08 17:04:22
Message-ID: 3FAD2216.4050403@meerkatsoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,
I want to remove data that is older that a certain number of months..
only full months.

example: today is 11-08 and I want do delete all data that is older than
this month - 3 month i.e. i want to delete all information that is older
than Aug. 1st.

Is there an easy way to do that ? Interval cannot be used and I cannot
just pass something like now()::date < '2003-08'

Thanks for any help here
Alex

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruno Wolff III 2003-11-08 17:28:54 Re: Help With date/time
Previous Message Tom Lane 2003-11-08 17:00:13 Re: pg_autovacuum causes 'create database' to fail when the