Eugene Ganancial Eugene Ganancial - 1 year ago 79
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.

Answer Source

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().

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download