Returns the ordinal number of the month of a particular date, from 1-12, where 1 is January, 2 is February, and so on.
- date - the Date value to be evaluated by the function.
- Return type: Number
month('2020-05-12') returns 5.
Supported data types
If a Date value is passed, the ordinal number of the month will be returned as a Number value.
Unsupported data types
Unsupported data types return Null.
Updated 03 May 2023
Did this page help you?