Get Month mysql code example Example 1: mysql extract month SELECT EXTRACT(MONTH FROM '2020-07-05') Example 2: month mysql SELECT MONTH("2017-06-15");