correct representation of timestamp difference

Started by phil campaigneover 21 years ago1 messagesgeneral
Jump to latest
#1phil campaigne
pcampaigne@charter.net

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