maria-discuss team mailing list archive

[Sergei Golubchik <serg@xxxxxxxxxxx>]

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@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 
> `sql_mode=NO_ZERO_DATE,NO_ZERO_IN_DATE,ALLOW_INVALID_DATES` does not 
> suffice.
> 
> With kind regards,
> 
> William Edwards
>