How to get month from the date field in sql server 2008

Question

I am using this

SELECT CONVERT(INT(4), DateOfDeposit, 100) FROM ABC

It gives the months like jan, feb but i want the no. representation like 1 for jan,2 for feb. How?

gregjer · Accepted Answer · 2013-12-19 10:41:54Z

3

SELECT Month(DateOfDeposit) FROM ABC

answered Dec 19, 2013 at 10:41

2,8432 gold badges20 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1