Skip to main content

Unable to finish service due to mysql date in db

question_mark_1.png

Question

What to do in case of error Unable to convert MySQL date/time to System.DateTime, set AllowZeroDateTime=True or ConvertZeroDateTime=True in the connection string. See https://mysqlconnector.net/connection-options/ ?


Answer

If this error occurs, it should be enough to put at the end connection stringu ConvertZeroDateTime=True;.