Syntax

MONTH(date)

Description

Returns the month for date in the range 1 to 12 for January to December, or 0 for dates such as '0000-00-00' or '2008-00-00' that have a zero month part.

Examples

SELECT MONTH('2013-08-03');
+---------------------+
| MONTH('2013-08-03') |
+---------------------+
|                   8 |
+---------------------+

SELECT MONTH('2013-00-00');
+---------------------+
| MONTH('2013-00-00') |
+---------------------+
|                   0 |
+---------------------+

Comments

Comments loading...