Mega Code Archive

 

Categories / MySQL / Date Time

 

SELECT DATE_FORMAT(2005-12-31, %D of %M)

mysql> mysql> SELECT DATE_FORMAT('2005-12-31', '%D of %M'); +---------------------------------------+ | DATE_FORMAT('2005-12-31', '%D of %M') | +---------------------------------------+ | 31st of December                      | +---------------------------------------+ 1 row in set (0.00 sec)