>I am using MariaDB 3.1 ODBC connector, and get the following error:
>

>pdDate = {}
>SQLEXEC(nHandl, "Update Users set Changed = ?pdDate")
>&& Error message: Incorrect date value: '' for column users.ChangeD.
>

>
>The same works in MySQL without problems. Also when I change the code it would work, but I don't feel comfortable with this solution:
>

>pdDate = 0
>SQLEXEC(nHandl, "Update Users set Changed = ?pdDate")
>

>
>Also the following works:
>

>pdDate = DATE()
>SQLEXEC(nHandl, "Update Users set Changed = ?pdDate")
>

>
>Is this a problem with the ODBC driver or some setting I could look at?

Maybe https://mariadb.com/kb/en/how-to-define-a-date-in-order-to-import-an-empty-date-from-a-csv-file/ ?