How can I get the month number (not month name) from a date in SQL Server?

Question

How can I get the month number in sql? I use the following code but it returns the month name.

SELECT DATENAME(mm, GETDATE())

Answer 1

Use datepart function with m extension.

SELECT DATEPART(m, getdate())

Answer 2

Use the month function - SELECT MONTH(GETDATE())

Answer 3

Use Datepart:

DATEPART(mm,getdate());