SQL•SQL References

MySQL MONTH() Function

Example

SELECT MONTH("2017-06-15");

Definition and Usage

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

Syntax

MONTH(
date
)

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

Works in:	From MySQL 4.0

Loading lesson path

SQL•SQL References

Example

SELECT MONTH("2017-06-15");

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

Syntax

MONTH(
date
)

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

Works in:	From MySQL 4.0