dbTalk Databases Forums  

correct representation of timestamp difference

comp.databases.postgresql.general comp.databases.postgresql.general


Discuss correct representation of timestamp difference in the comp.databases.postgresql.general forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
phil campaigne
 
Posts: n/a

Default 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


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.