mysql extract month from date
snippet in sql

mysql extract month

user7152

SELECT EXTRACT(MONTH FROM '2020-07-05')

mysql extract month from date

user5366

SELECT MONTH(field_name) as month FROM yourtable