maria-discuss team mailing list archive

[William Edwards <wedwards@xxxxxxxxxxxxxx>]

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