how to get a date diffence by substractig a year

SQL DATEDIFF() function is used to calculate the difference between two dates.