DATENAME

This function returns a character string representing the specified datepart of the specified date.

Syntax

DATENAME ( datepart , date )