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 secur...@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 > _______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
