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 are "0000-00-00" data values in the Date column to fix this problem, you can either set the data to null or set "Allow Zero datetime=true" in the connection string

Cases:

<add name= "Mysqlcon" connectionstring= "Database=test;data source=localhost; User Id=root; Password=123456;pooling=false; Charset=utf8; Port=3306;allow Zero datetime=true "/>

Unable to convert MySQL date/time value to System.DateTime