We can use below query to get month from a date column in MySQL.

mysql> SELECT MONTH(date_column) FROM table_name