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