I’m running MySql Server 5.7.11 and this sentence: is not working. Giving the error: But the following: just works. The same case for DATE. As a sidenote, it is mentioned in the MySQL docs: The DATE type is used for values with a date part but no time part. MySQL retrieves and displays DATE values in ‘YYYY-MM-DD’ format. The supported