The Ultimate Guide to High Availability with MariaDB

MariaDB ODBC 3.2.2 insert zero date for empty strings

You are viewing an old version of this question. View the current version here.

Hello,

I am using the MariaDB ODBC 3.2.2 driver on rhel 9.4 and have encountered an issue with handling DateTime columns. When I insert empty values into a DateTime column, they are stored as 0000-00-00 00:00:00 (zero datetime).

Is there a way to configure the ODBC driver or MariaDB settings so that these zero datetime values are retrieved as NULL instead?

Any guidance or suggestions would be greatly appreciated.

Thank you!

Comments

Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.