Description
Returns an integer that represents the month of the specified date. ().
Sample Source Pattern
Syntax
MONTH ( <date_or_timestamp_expr> )
Examples
Code:
SELECT MONTH('10-10-2022') AS MONTH
Result:
Code:
SELECT MONTH('10-10-2022' :: TIMESTAMP) AS MONTH;
Result: