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