datepart

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

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

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