MySQL MONTH() Function
Definition and Usage
The MONTH() function returns the month part for a given date (a number from 1 to 12).
Syntax
MONTH(date)
Parameter Values
Parameter | Description |
---|---|
date | Required. The date or datetime to extract the month from |
Technical Details
Works in: | From MySQL 4.0 |
---|
More Examples
Example
Return the month part of the current system date:
SELECT MONTH(CURDATE());
Try it Yourself »