Postgres Pro
Downloads
Home   >   mailing lists

correct representation of timestamp difference - Mailing list pgsql-general

From phil campaigne
Subject correct representation of timestamp difference
Date
Msg-id 416D910B.5000006@charter.net
Whole thread Raw
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: David Rysdam
Date:
Subject: Re: Date format for bulk copy
Next
From: ruben
Date:
Subject: Re: Recovering data from corrupted table. Urgent Help!!