How do I get the month and day with leading 0's in mysql code example Example: mysql extract day from date leading zero DATE_FORMAT(field_name,'%Y-%m-%d')