correct representation of timestamp difference -
10-13-2004
, 03:33 PM
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
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend |