MONTH

Retrieve the month component from a given date.

SELECT MONTH(“2017-06-15”);

Definition and Usage

The MONTH() function retrieves the month component from a given date, represented as a number from 1 to 12.

MONTH(date)

Parameter	Description
date	Mandatory: The date or datetime value from which to extract the month.

Works in:

From MySQL version 4.0

Retrieve the month component from a specified date.

SELECT MONTH(“2017-06-15 09:34:21”);

Retrieve the month component from the current system date.

SELECT MONTH(CURDATE());