Simple MySQL query...

[dannyluked]

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!

[clay1]

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

 

 

[MarioRossi]

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