MONTH

Sorting in order of days of birth

SELECT statement

DATEPART function

T-SQL Datetime functions