Date Time MySQL

  1. Home
  2. MySQL
  3. Date Time
  4. 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)