EXTRACT

DATEDIFF function

T-SQL Datetime functions

DATEPART function

T-SQL Datetime functions