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