Tips on select/query/calculate N days/month with MySQL date/timestamp field
If you want filter your sql query results with date and time such as older or earlier than a specific date, you can use the following functions: DATE_SUB or DATE_ADD. See the tips below.