number month mysql timstamp code example

Example 1: mysql extract month

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

Example 2: month mysql

SELECT MONTH("2017-06-15");