dannyluked Posted January 10, 2010 Share Posted January 10, 2010 Hello, How could I do a mysql query that does this: SELECT * WHERE date/time < 5minutes ago? Also, what type of field will I need to create in the database? date/time or just time? And, what type of date/time function would I use to insert the data? would I just use UNIX Timestamp? Thanks! Quote Link to comment Share on other sites More sharing options...
clay1 Posted January 10, 2010 Share Posted January 10, 2010 I use Postgre and have a timestamp field in my table I update it with: UPDATE YOURTABLE SET TIMESTAMPCOLUMN = now() WHERE RECORDYOUWANT = 'whatever' You may need to edit the syntax for your database backend For the select: DATE_ADD(NOW(), INTERVAL -5 MINUTES) will do the math part Quote Link to comment Share on other sites More sharing options...
MarioRossi Posted January 10, 2010 Share Posted January 10, 2010 SELECT * FROM table WHERE DATE_SUB(CURDATE(), INTERVAL 5 Minutes) <= date_col; If you're using MySQL's date field types. This should help... http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.