years_sub
Description
Subtracts the specified number of years from the specified datetime or date.
Syntax
DATETIME YEARS_SUB(DATETIME date, INT years)
Parameters
-
date
: The original date time, of type DATETIME or DATE. -
years
: The number of years to subtract. The value can be negative, but date year minus years can't exceed 10000. For example, if the year of date is 2022, then years can't be less than -7979. At the same time, the years cannot exceed the year value of date, for example, if the year value of date is 2022, then years can't be greater than 2022.
Return value
The return value type is the same as the parameter date
. Returns NULL if the result year is out of range [0, 9999].
Examples
select years_sub("2022-12-20 15:50:21", 2);
+-------------------------------------+
| years_sub('2022-12-20 15:50:21', 2) |
+-------------------------------------+
| 2020-12-20 15:50:21 |
+-------------------------------------+