Unable to convert MySQL date/time value to system. datetime

When you use. Net connector to connect to the MySQL database and retrieve some data, you may get an error message:

"Unable to convert MySQL date/time value to system. datetime"

This is because there is a "0000-00-00" data value in the date column. To solve this problem, you can set the data to null, or set "allow zero datetime = true" in the connection string"

Example:

<Add name = "mysqlcon" connectionstring = "database = test; Data Source = localhost; user id = root; Password = 123456; pooling = false; charset = utf8; Port = 3306; allow zero datetime = true "/>