SQL - Extract month from current date

If you want to extract the month of the current date directly, then use CURRENT_TIMESTAMP

SELECT EXTRACT(MONTH FROM CURRENT_TIMESTAMP)

EXTRACT() is a SQL standard function supported by MySQL, Oracle, and PostgreSQL Databases.