Rows with a DateTime in the past
$sql1 = "SELECT * FROM my_table WHERE my_date_field < NOW()";Time based condition
$sql1 = "SELECT * FROM tblStatus WHERE LastCheckin > DATE_SUB(now(), INTERVAL 5 MINUTE)";
$sql1 = "SELECT * FROM tblStatus WHERE LastCheckin < DATE_ADD(now(), INTERVAL 5 MINUTE)";Argument can be:
- MICROSECOND
- SECOND
- MINUTE
- HOUR
- DAY
- WEEK
- MONTH
- QUARTER
- YEAR
Feel free to comment if you can add help to this page or point out issues and solutions you have found. I do not provide support on this site, if you need help with a problem head over to stack overflow.