[thelist] MySQL date format

Jay Blanchard jay.blanchard at THERMON.com
Mon Nov 28 08:08:08 CST 2005

I've a DATE column in MySQL with a row, say "2005-12-1". I want to return
following string:

Thursday, 1 - 2 December 2005

Is that possible with MySQL functions, or do I have to get PHP to do that?

You can use MySQL's DATE_FORMAT() function

More information about the thelist mailing list