Example
Return a specified part of a date:
SELECT DATEPART(year, '2017/08/25') AS DatePartInt;
Definition and Usage
The DATEPART() function returns a specified part of a date.
This function returns the result as an integer value.
Syntax
DATEPART(interval, date)