Team Exasol
Team Exasol


IMPORT of a timestamp column fails, because 0000-00-00 00:00:0000, which is a valid timestamp in MySQL, is invalid as a timestamp in EXASolution.


The JDBC connection string parameter 'zeroDateTimeBehavior=convertToNull' allows importing this timestamps as NULL values.

How to add this parameter in the connection string:


Additional Notes

See for further details on this parameter.

NOTE: As of version 6.1, you need the system privilege IMPORT to perform an IMPORT statement.