Converting MySQL DATETIME to System.DateTime

Question

I am using a MySQL database with DbLinq, but there is an exception being thrown:

"Cannot convert mysql datetime to system.datetime"

How can I resolve this issue?

Answer 1

Check for any zero date means date like '0000-00-00' in database; this could be the cause of error.

Answer 2

Either cast the MySqlDateTime as a DateTime or use mySqlDateTime.GetDateTime().