MySQL date/time conversion error¶

When you receive this errror: Error: Unable to convert MySQL date/time value to System.DateTime

In the Database Connection Screen select “Advanced Connection Info”.

../_images/dbconn.png

Type “Convert Zero Datetime=true” in the string box.

../_images/adddy.png

Use Convert Zero Datetime=true returns DateTime.MinValue instead of a MySqlDateTime.