Mega Code Archive
SELECT DATE_FORMAT(2005-12-31, %M %d %Y)
mysql>
mysql> SELECT DATE_FORMAT('2005-12-31', '%M %d %Y');
+---------------------------------------+
| DATE_FORMAT('2005-12-31', '%M %d %Y') |
+---------------------------------------+
| December 31 2005 |
+---------------------------------------+
1 row in set (0.00 sec)