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