correct representation of timestamp difference

Поиск
Список
Период
Сортировка
От phil campaigne
Тема correct representation of timestamp difference
Дата
Msg-id 416D910B.5000006@charter.net
обсуждение исходный текст
Список pgsql-general
Hi
 I'm trying to create a select statement that will return all rows that
are older than 30 milleseconds.  Is either of these correct?
select event_id from event where (current_timestamp-timestamp)>.030
or
select event_id from event where
(current_timestamp-timestamp)>000000030.000000
thanks,
Phil


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