Provide the segment of a date representing the month.
|
SELECT MONTH(‘2017/08/25’) AS Month; |
The MONTH() function retrieves the numeric representation of the month from a given date, ranging from 1 to 12.
|
MONTH(date) |
|
Parameter |
Description |
|
date |
Mandatory. The date or datetime from which the month is to be extracted. |
|
Return type: |
int |
|
Works in: |
SQL Server (from 2008 onward), Azure SQL Database, Azure SQL Data Warehouse, and Parallel Data Warehouse |
Retrieve the numerical month component from a date.
|
SELECT MONTH(‘2017/05/25 09:08’) AS Month; |