Skip to main content
Skip to main content

MONTH

month

Description

Syntax

INT MONTH (DATETIME date)

Returns month information in the time type, ranging from 1,12

The parameter is Date or Datetime type

example

mysql> select month('1987-01-01');
+-----------------------------+
| month('1987-01-01 00:00:00') |
+-----------------------------+
| 1 |
+-----------------------------+

keywords

MONTH