Jump to content

dealing with timestamp *SOLVED*


yahn

Recommended Posts

It would be something like the example below. Rows will get selected when the timestamp value in your column_name is older or equal to 15 minutes from the current date/time.

SELECT * FROM table_name WHERE column_name <= DATE_SUB(NOW(), INTERVAL 15 MINUTE)

You didn't post your MySQL version, however, you can look at all the date and time functions here:
http://dev.mysql.com/doc/refman/4.1/en/date-and-time-functions.html

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.