datename

Returns "datepart" of "date_expression" as an ASCII string. "Date_expression" can be a datetime, smalldatetime, date, or time value. Note that "datepart" must be enclosed in curly brackets.

datename ( ' { ' datepart ' } ' , date_expression )

datename ( {mm} , 1999-05-01 )