Eugene Ganancial Eugene Ganancial - 6 months ago 32
SQL Question

How to select data with overdue dates? Mysql

I wanted to select data which has an overdue dates.
For example,
Deadline is 9-9-2016 and the date today is 10-10-2016.
Clearly 9-9-2016 is already overdue.


Well, you can try to use NOW() function in where clause to check overdue dates. Somethisn like this:

select * from your_table where your_date < NOW()

Also you can try use CURDATE() instead of NOW().