Bind Minimal Date As Zero Date

Min_Date_To_Zero

Key Name	Default Value	Required
`Min_Date_To_Zero`	Clear (`0`)`0`	No

Description

This option specifies whether the connector translates the minimum ODBC date value (0000-01-01) to the zero date value used in MySQL (0000-00-00) when binding parameters. Enabling this option prevents statements from failing because of what seems to be a mismatch in the date values.

Enabled (1)1: The connector translates the minimum ODBC date value to the MySQL zero date value when binding parameters.
Disabled (0)0: The connector does not modify the date values.

Using a Connection String
Configuring Additional Connector Options
Creating a Data Source Name
Configuring a DSN-less Connection
Additional Driver Configuration Options