YEARS_SUB
Subtracts a specified number of years from a date.
Analyze Syntax
func.years_sub(<date>, <n>)
Analyze Examples
func.years_sub('2029-01-01', 5)
┌──────────────┐
│ '2024-01-01' │
└──────────────┘
SQL Syntax
YEARS_SUB(<date>, <n>)
SQL Examples
SELECT YEARS_SUB('2029-01-01', 5);
┌────────────┐
│ 2024-01-01 │
└────────────┘