>>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/ ?

Thank you very much! Indeed, I had to set SQL_Mode strict off. Apparently this is now set by default since some versions ago.