Mysql date subtract function

The DATE_SUB() function subtracts a specified time interval from a date.

Syntax.

DATE_SUB(date,INTERVAL expr type)

Examples:

SELECT DATE_SUB(now(), INTERVAL 10 DAY);  

Result: