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