MySQL Function Reference

MONTH

Returns the numeric value of the month of the year (from 1 to 12) for a date

MySQL 8.1

MONTH(datetime)

Examples

MySQL 8.1

SELECT MONTH("2022-06-16");