MySQL Format Date helps you format your dates using the MySQL DATE_FORMAT function.  Just select a common date format and then change it to your suit your needs. The MySQL DATE_FORMAT code will be generated at the bottom of the page which you can then copy into your query.

Format dates in php using date() function