DATE_SUB

Use DATE_SUB to subtract or add a number of days from a date. A positive number subtracts days. A negative number adds days.

Syntax

DATE_SUB(date_expression, number_of_days)