month()

returns the ordinal number of the month of a particular date, from 1 12, where 1 is january, 2 is february, and so on syntax month(date) date the date value to be evaluated by the function return type number docid\ uci5tctfvbhonej6zqijg sample usage month('2020 05 12') returns 5 supported data types input type return type logic date docid\ xtaqdzvlbtakjxrnpfwe9 number docid\ uci5tctfvbhonej6zqijg if a date value is passed, the ordinal number of the month will be returned as a number value unsupported data types null docid\ n9trvqonnbknql9drnbp6 unsupported data types return null