Thread: correct representation of timestamp difference

correct representation of timestamp difference

From
phil campaigne
Date:
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