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 (node address): Invalid DATE/TIME in type conversion for column column name]

Environment

• HVR 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.