CODEWITHSUNDEEP
c#mysqldatetimeidatareader
Jhonny D. Cano -Leftware-
Jhonny D. Cano -Leftware-

Reputation: 18013

MySqlConversionException when accessing DateTime field from DataReader

I have a C# application over MySql, using MySQL Connector; I'm trying to make a DataReader request, the query executes fine, however, when trying to access a DateTime field, i'm getting MySqlConversionException {"Unable to convert MySQL date/time value to System.DateTime"}

this is the prototype

if (dr != null && !dr.Read()) return;

sesion.Id = Convert.ToInt32(dr["id"]);
sesion.Usuario = Convert.ToInt32(dr["usuario"]);
sesion.Estado = Convert.ToByte(dr["estado"]);
// doesn't work
sesion.FchCreacion = Convert.ToDateTime(dr["fch_creacion"]);

Any suggestions? Thanks in advance

Upvotes: 5

Views: 4448

Answers (4)

LukeH
LukeH

Reputation: 269368

There are a few potential gotchas when converting between MySQL dates/times and .NET DateTimes, but there's a useful section in the MySQL documentation with advice on how to handle the issues.

Upvotes: 2

David M
David M

Reputation: 72870

This error sometimes occurs if you have zero datetime values in your MySQL database (00/00/0000 00:00). Try adding this to the end of your connection string:

Allow Zero Datetime=true

Upvotes: 12

Joel Coehoorn
Joel Coehoorn

Reputation: 415735

It could also be a DBNull value.

Upvotes: 0

cjk
cjk

Reputation: 46425

I'd suggest it may be a culture specific error - is the applicaiton on the same server as the DB, and do they have the same culture settings?

Also, is the column definitely a datetime in MySQL?

Upvotes: 0

Related Questions