Minimum value for DATE and DATETIME(6) data types

As per the memsql documentation, DATE and DATETIME(6) has the following minimum values.

DATE                1001-01-01
DATETIME(6)         1000-01-01 00:00:00.000000

But when i inserted the below values in these columns, there were no issues.

DATE                0001-01-01
DATETIME(6)         0001-01-01 00:00:00.000000

Are the minimum values enforced during INSERT ?

Our officially supported minimums are as stated in the documentation. The code will accept lower values as your test showed.

1 Like

You can modify the data_conversion_compatibility_level system variable to get errors in this case instead.