How can I get the month number (not month name) from a date in SQL Server? September 18, 2023 by Tarik Use datepart function with m extension. SELECT DATEPART(m, getdate())