mysql get day from date code example Example: mysql extract days SELECT EXTRACT(DAY FROM '2020-07-05')