View Single Post
  #1 (permalink)  
Old 09-29-2007, 10:04 PM
andrecal
Guest
 
Posts: n/a
Default SELECT all records that occurred in the last five minutes or less

I have a table with a TIMESTAMP entry, and I would like to find a
query that will look at this table and only return results that shows
the TIMESTAMP to be five minutes ago or less.

Something along these lines:
SELECT * FROM table_name WHERE entry_date BETWEEN NOW() AND NOW()-5
minutes ago

entry_date is a full timestamp

any help appreciated,
AN

Reply With Quote