get month from mysql date code example Example 1: mysql extract month SELECT EXTRACT(MONTH FROM '2020-07-05') Example 2: extract month from date in mysql MONTH(date)