Loading lesson path
Concept visual
Start at both ends
Return the month part of a date:
SELECT MONTH('2017/08/25') AS Month;The MONTH() function returns the month part for a specified date (a number from 1 to 12).
date )
Required. The date or datetime to extract the month from
int
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;
❮ SQL Server Functions