correct representation of timestamp difference

From: phil campaigne <pcampaigne(at)charter(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: correct representation of timestamp difference
Date: 2004-10-13 20:33:15
Message-ID: 416D910B.5000006@charter.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-general by date

  From Date Subject
Next Message Eric D. Nielsen 2004-10-13 20:33:56 Has anyone tried Date/Darwen/Lorentzos's model for temporal data?
Previous Message Josh Berkus 2004-10-13 20:08:38 Re: [pgsql-advocacy] [GENERAL] Reusable pl/pgsql