mysql show month of year code example

Example: mysql extract month

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