mysql extract month
snippet in sql

mysql extract month

user8956

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

mysql extract days

user3578

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