SOLVED - Re: SELECT NOW() Yields 2018-00-00 0:00:00, NOT Full Date & Time

[Gregg Leichtman]

After some installation app failures to upgrade the server from 5.7.21 to 5.7.23, the app finally succeeded in making it through the upgrade of the server and supporting tools. Prior to the upgrade I noticed that MySQL Workbench was correctly displaying the date and time (pretty sure it wasn't before), but the MySQL Shell was displaying the incorrect date and time as described in the subject line of this message. I then noticed that MySQL Shell was version 1.0.11.

I proceeded with the server upgrade to 5.7.23. Most of the supporting tools and components were upgraded to 8.0.12 including MySQL Shell. Once I ran the new MySQL Shell, I found that select now() displayed correctly as shown below:

Server version: 5.7.23-log MySQL Community Server (GPL)
No default schema selected; type \use <schema> to set one.

MySQL localhost:3306 SQL > select now();
+---------------------+
| now() |
+---------------------+
| 2018-08-05 08:08:56 |
+---------------------+
1 row in set (0.0002 sec)

MySQL localhost:3306 SQL >

-=> Gregg <=-