Обсуждение: correct representation of timestamp difference

Поиск
Список
Период
Сортировка

correct representation of timestamp difference

От
phil campaigne
Дата:
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