MONTH
Returns the month of a date or dateTime value. The month is returned as an integer in the range 1 - 12.
Syntax
MONTH ( date | dateTime ) |
Inputs
- date or dateTime - The date or dateTime value of which the month must be returned.
Return type
- integer
Examples
| Expression | Result | Type |
|---|---|---|
| MONTH ( DATE ( 2015 , 01 , 01 ) ) | 1 | Integer |
| MONTH ( DATE ( 1978 , 04 , 11 ) ) | 4 | Integer |