MySqlConversionException when accessing DateTime field from DataReader

Question

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

David M · Accepted Answer · 2009-04-02 15:25:15Z

12

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

answered Apr 2, 2009 at 15:25

David M

73.2k13 gold badges164 silver badges187 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

LukeH · Accepted Answer · 2015-03-11 14:24:23Z

2

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.

edited Mar 11, 2015 at 14:24

answered Apr 2, 2009 at 15:35

LukeH

271k59 gold badges373 silver badges411 bronze badges

1 Comment

LukeH Over a year ago

@jkw4703: I've fixed the link.

cjk · Accepted Answer · 2009-04-02 15:24:07Z

0

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?

answered Apr 2, 2009 at 15:24

cjk

46.6k9 gold badges83 silver badges113 bronze badges

Comments

Joel Coehoorn · Accepted Answer · 2009-04-02 15:25:04Z

0

It could also be a DBNull value.

answered Apr 2, 2009 at 15:25

Joel Coehoorn

418k114 gold badges582 silver badges820 bronze badges

Collectives™ on Stack Overflow

MySqlConversionException when accessing DateTime field from DataReader

4 Answers 4

Comments

1 Comment

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related