← Back to team overview

maria-discuss team mailing list archive

Re: Disable validation for `DATETIME` columns


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.

VP of MariaDB Server Engineering
and security@xxxxxxxxxxx

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 
> suffice.
> With kind regards,
> William Edwards

Follow ups