Example
Subtract 10 days from a date and return the date:
SELECT SUBDATE("2017-06-15", INTERVAL 10 DAY);
Definition and Usage
The SUBDATE() function subtracts a time/date interval from a date and then returns the date.
Syntax
SUBDATE(date, INTERVAL value unit)
OR:
SUBDATE(date, days)