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 : [email protected]
Unsubscribe : https://launchpad.net/~maria-discuss
More help : https://help.launchpad.net/ListHelp