This is an old post from 2010. As such, it might not be relevant anymore.
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.