Reference Guide
>
TDV Support for SQL Functions
>
Date Functions
>
DATE_SUB
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