how to fetch month from date in sql using PHP code code example

Example 1: mysql extract month

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

Example 2: month mysql

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