DATE_SUB

The DATE_SUB() function subtracts days from a date or timestamp expression.

Syntax

DATE_SUB(datetime_value_expression, integer_expression)

Example

SELECT DATE_SUB('2020-11-02',1)

The above query returns

2020-11-01