SELECT MONTH('10/23/2010') Month
Month ----- 10
select DATEPART(month,'12/02/2012')
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)