query for records based on date

Поиск
Список
Период
Сортировка
Искать
От
Brandon Metcalf
Тема
query for records based on date
Дата
Msg-id
Pine.LNX.4.58L.0502211356580.24449@cash.rhiamet.com
Список
Дерево обсуждения
query for records based on date "Brandon Metcalf" <bmetcalf@nortel.com>
Re: query for records based on date Martín Marqués <martin@bugs.unl.edu.ar>
Re: query for records based on date "Brandon Metcalf" <bmetcalf@nortel.com>
Re: query for records based on date Richard Huxton <dev@archonet.com>
If I have a table with an attribute of type "timestamp without time
zone", what is the best way to query that table for records that are
older than, say, one week.

I suppose I could get the current time in epoch seconds and the time of
the attribute in the same, and select those records where the difference
is greater than the number of seconds in a week.  Is there something
easier like
 SELECT * FROM table WHERE attribute IS OLDER THAN one week;

Thanks.

-- 
Brandon

В списке pgsql-sql по дате отправления
От: Achilleus Mantzios
Дата:
От: Martín Marqués
Дата:
FAQ