I'm trying to view the preview of a table that contains MySQL-timestamps of type datetime. Some of the values are 0 and mysql explorer says: "No detail information available for Cannot convert value '0000-00-00 00:00:00' from column 7 to TIMESTAMP'. Same thing happens when I SELECT something from a table containing stuff like that. It would be nice if I'd still get to see some results either with the literal value (that can be displayed by the error message after all) or with something like 'NULL'.
Log in to post a comment.