Beefy Boxes and Bandwidth Generously Provided by pair Networks
Problems? Is your data what you think it is?
 
PerlMonks  

(OT) Don't blow that index dude.

by demerphq (Chancellor)
on Nov 29, 2005 at 09:00 UTC ( [id://512547] : perlmeditation . print w/replies, xml ) Need Help??

Help for this page

Select Code to Download


  1. or download this
    SELECT event_id, tstamp FROM events 
    WHERE UNIX_TIME(tstamp) > UNIX_TIME(NOW())-600
    
  2. or download this
    SELECT event_id, tstamp FROM events 
    WHERE tstamp > DATE_SUB(NOW(),INTERVAL 10 MINUTE)