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

.net asp.net mysql asp.net-3.5
Ankit Chauhan picture Ankit Chauhan · Apr 22, 2011 · Viewed 131.3k times · Source

I get this error:

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

while I am trying to fetch the data from a MySQL database. I have the date datatype in my MySQL database. But while retrieving it into my datatable, it get the error above.

How can I fix this?

Answer

agni picture agni · Jun 27, 2012

You must add Convert Zero Datetime=True to your connection string, for example:

server=localhost;User Id=root;password=mautauaja;Persist Security Info=True;database=test;Convert Zero Datetime=True

Related questions

ASP.NET use SqlConnection connect MySQL

This is the connection string saved in web.config: <appSettings> <add key="conn" value="Driver={MySQL ODBC 5.1 Driver};server=127.0.0.1;uid=root;pwd=1234;database=gis_server;option=3"/> </appSettings> This is the code to connect to …

Read More
.NET & MySQL error - A call to SSPI failed ... "message received was unexpected or badly formatted" AND "buffers supplied to a function was too small"

I hope this is not too vague of a question, but I have looked far and wide but have not been able to find anything helpful for this error. I have a .NET 4.5.2 web service tier (using ServiceStack & Dapper) …

Read More
In C#, what is the difference between public, private, protected, and having no access modifier?

All my college years I have been using public, and would like to know the difference between public, private, and protected? Also what does static do as opposed to having nothing?

Read More