DATENAME

Returns text corresponding to the specified part of a given date

DATENAME(date, date_part)

Returns the date_part of date as a string

Arguments

Argument	Description
date	Date/time value(s)
date_part	Part of the date/time objects to return

Output

Text representing the desired date_part of a date

Example