Example
Return the difference between two date values, in years:
SELECT DATEDIFF(year, '2017/08/25', '2011/08/25') AS DateDiff;
Definition and Usage
The DATEDIFF() function returns the difference between two dates, as an integer.
Syntax
DATEDIFF(interval, date1, date2)