Mega Code Archive

 

Categories / MySQL Tutorial / Date Time Functions

 

SELECT DATE_FORMAT(2006-06-00, %d)

mysql> mysql> SELECT DATE_FORMAT('2006-06-00', '%d'); +---------------------------------+ | DATE_FORMAT('2006-06-00', '%d') | +---------------------------------+ | 00                              | +---------------------------------+ 1 row in set (0.00 sec) mysql>