SQL Server MONTH() Function

Return the month part of a date:

SELECT MONTH('2017/08/25') AS Month;

Definition and Usage

The MONTH() function returns the month part for a specified date (a number from 1 to 12).

MONTH(date)

Parameter	Description
date	Required. The date or datetime to extract the month from

Works in:	SQL Server (starting with 2008), Azure SQL Database, Azure SQL Data Warehouse, Parallel Data Warehouse

Return the month part of a date:

SELECT MONTH('2017/05/25 09:08') AS Month;