| Parameter | Type |
|---|---|
value | datetime, date, datetimestamp, gyear, gyearmonth |
Returns: integer
Example
query:
SELECT MONTH(CAST("2018-01-02" AS DATE))results:
| month |
|---|
| 1 |
MONTH
The date function used to return the month value of a date, time, or datetime value.