Date Calculation with specific date

Question

Heloo, I want to subtract 64.5 years in Eff_Date-2022-12-05 and want to get the result after subtracting 64.5 years (2022-12-05 minus 64.5 yrs).

Answer 1

Try

DECLARE @date DATE = '2022-12-05'

SELECT @date, DATEADD(MONTH, -1*64.5*12, @date) AS newDate

Answer 2

Try:

DECLARE @date DATE = '2022-12-05'
SELECT @date, DATEADD(MONTH, -1*64.5*12, @date) AS newDate