Loading lesson path
Concept visual
Start at both ends
Return the month part of a date:
SELECT MONTH("2017-06-15");The MONTH() function returns the month part for a given date (a number from 1 to 12).
date )
Required. The date or datetime to extract the month from
From MySQL 4.0
Return the month part of a date: SELECT MONTH("2017-06-15 09:34:21");
Return the month part of the current system date:
SELECT MONTH(CURDATE());❮ MySQL Functions