Hi, William, Could you provide a sequence of SQL commands demonstrating what exactly is not working? I've just tried and I was able to insert '2023-03-26 02:30:00' into a DATETIME column just fine. Regards, Sergei VP of MariaDB Server Engineering and security@mariadb.org On Mar 30, William Edwards wrote:
Hi,
Is it possible to disable validation for `DATETIME` columns?
Context:
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