Error: F_JD02C9 Invalid Date/Time in Type Conversion for Column

Issue

The following error appears on a SingleStore location:

• F_JD02C9: DBMS error [Leaf Error (<em>node address</em>): Invalid DATE/TIME in type conversion for column <em>column name</em>]

Environment

• DSS 6
• Target: SingleStore

Resolution

To resolve this issue, set the SingleStore global sync variable data_conversion_compatibility_level to 6.0.

To check the current data conversion compatibility level, use the following statement:

SELECT @@data_conversion_compatibility_level;

To set the data conversion compatibility level, use the following statement:

SET GLOBAL data_conversion_compatibility_level = '6.0';

Cause

SingleStore restricts possible values for Time and Date types; zero is prohibited by default. For more information, refer to the SingleStore data types documentation.