Help With date/time

Поиск
Список
Период
Сортировка
От Alex
Тема Help With date/time
Дата
Msg-id 3FAD2216.4050403@meerkatsoft.com
обсуждение исходный текст
Ответы Re: Help With date/time  (Bruno Wolff III <bruno@wolff.to>)
Re: Help With date/time  (Steve Crawford <scrawford@pinpointresearch.com>)
Список 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



В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: pg_autovacuum causes 'create database' to fail when the
Следующее
От: Bruno Wolff III
Дата:
Сообщение: Re: Help With date/time