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