Using Mysql date functions
Sunday, June 29th, 2008This is something that slipped by me for a long time.
Like many other developers I know, I have written a function that takes a date from mysql (In any of the relevant formats, usually datetime though) and then formats it (Using substr() or strtotime() and date()) with PHP into a nice human readable format for display on the website.
There is a more elegant solution however.