← Back to team overview

maria-discuss team mailing list archive

Disable validation for `DATETIME` columns



Is it possible to disable validation for `DATETIME` columns?


A customer uses the Europe/Amsterdam session time zone. Therefore, they cannot insert dates during the hour in which DST starts and ends.

Using the UTC session time zone would solve the issue. However, they also use auto-converting `TIMESTAMP` columns. Switching to a different session time zone would cause issues with those.

Relaxing constraints with `sql_mode=NO_ZERO_DATE,NO_ZERO_IN_DATE,ALLOW_INVALID_DATES` does not suffice.

With kind regards,

William Edwards

Follow ups