TODAY and CURRENT?

Поиск
Список
Период
Сортировка
От Raymond Chui
Тема TODAY and CURRENT?
Дата
Msg-id 3A3F80C6.64A9DF6C@noaa.gov
обсуждение исходный текст
Ответы RE: TODAY and CURRENT?  ("Francis Solomon" <francis@stellison.co.uk>)
Re: TODAY and CURRENT?  (Mike Castle <dalgoda@ix.netcom.com>)
Список pgsql-general
I have a table with columns

datetime   timestamp,
value        float(8)

I want to delete rows 10 days older or 10 hours older by

delete from tablename where datetime < TODAY-10;
or
delete from tablename where datetime between CURRENT-10 and CURRENT;

So are there key words TODAY, CURRENT in PostgreSQL?

Thank you!

Вложения

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

Предыдущее
От: "Joseph"
Дата:
Сообщение: Help me for "DBI->connect failed: Sorry, too many clients already."
Следующее
От: Marc SCHAEFER
Дата:
Сообщение: Re: Help me for "DBI->connect failed: Sorry, too many clients already."