TODAY and CURRENT?

Поиск
Список
Период
Сортировка
От Raymond Chui
Тема TODAY and CURRENT?
Дата
Msg-id 3A3F80C6.64A9DF6C@noaa.gov
обсуждение исходный текст
Ответы RE: TODAY and CURRENT?
Re: TODAY and CURRENT?
Список 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 по дате отправления: