Get the current month number in SQL Server, 1 for january, 12 for december

This is the way to get

SELECT MONTH('2015-10-16 00:00:00')

output

10

How about this:

SELECT MONTH(GETDATE())

This will return values 1 through 12 depending on the month.

See the relevant MSDN documentation for details - that entire documentation site is freely available for consultation by everyone - use it!

Try:

SELECT DATEPART(MONTH, GETDATE())

You may try like this:

SELECT MONTH(datecolumn) from table

Also check for more details about MONTH

Related