DATENAME
DATENAME([Created On], 'year')Syntax
DATENAME(date expression, date part)
Function which returns provided date part of date as a text.
date expression: Date calculation created using date functions, data fields or constants.
date part: Text constant which can be chosen from minute, hour, dayofweek, dayofmonth, dayofyear, week, month, quarter, year