Postgres Pro
Downloads
Home   >   mailing lists

Help With date/time - Mailing list pgsql-general

From Alex
Subject Help With date/time
Date
Msg-id 3FAD2216.4050403@meerkatsoft.com
Whole thread Raw
Responses Re: Help With date/time  (Bruno Wolff III <bruno@wolff.to>)
Re: Help With date/time  (Steve Crawford <scrawford@pinpointresearch.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: pg_autovacuum causes 'create database' to fail when the
Next
From: Bruno Wolff III
Date:
Subject: Re: Help With date/time