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)";

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.

Comments

Your email address will not be published.