Code not working

[Barand]

The code I used gives that format

mysql> SELECT CASE WHEN FINISHED = 0
    ->         THEN ''
    ->         ELSE DATE_FORMAT(FINISHED, '%d %M %Y')
    ->        END as FINISHED
    -> FROM games
    -> ORDER BY FINISHED DESC
    -> LIMIT 5;
+------------------+
| FINISHED         |
+------------------+
| 31 October 2016  |
| 31 December 2016 |
| 29 October 2018  |
| 29 June 2019     |
| 29 January 2017  |
+------------------+

 

For future consistency of content you should

EITHER

ALTER TABLE `games` 
CHANGE COLUMN `FINISHED` `FINISHED` DATE NOT NULL DEFAULT '0000-00-00' ;

to prevent new records having the date set to NULL

OR

Change those "0000-00-00" dates back to NULL