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?

How are you casting/converting it now? – Ariel Dec 28 '09 at 05:56 — Ariel, Dec 28 '09 at 05:56
Is the MySql date a unix timestamp? – Kris Krause Jan 30 '10 at 16:32 — Kris Krause, Jan 30 '10 at 16:32

score 4 · Answer 1 · edited Jan 09 '12 at 00:51

4

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

edited Jan 09 '12 at 00:51

answered Aug 23 '11 at 07:50

John

49
1
2

score 3 · Answer 2 · edited Apr 13 '21 at 18:12

3

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

edited Apr 13 '21 at 18:12

Ian Kemp

28,293
19
112
138

answered Dec 28 '09 at 05:45

user239412

31
2

score 1 · Answer 3 · answered Oct 22 '09 at 13:21

Well, if you have a result set containing MySql DateTime values, you could use the ConvertAll method along with a delegate using DateTime.Parse to create a collection of System.DateTime values.

Here's an example, where "results" is the result of your dblinq query containing MySQL datetime values:

List<DateTime> dateTimes = results.ConvertAll(delegate(string time){ 
   return DateTime.Parse(time); 
});

Is this what you're looking for?

score 1 · Answer 4 · answered Apr 05 '11 at 16:44

I was moving a column in my gridview from asp:BoundField to asp:TemplateField so had to display a date from a MySQL database explicitly. I found, through reflection, that the collection typed the date fields as MySqlDateTime and not system.DateTime.

I added the import MySql.Data.Types statement to the code behind and the following Eval statement within a label in the context of a gridview.

Text='<%# CType(Eval("Submitted_Date"), MySql.Data.Types.MySqlDateTime).ToString%>'

output format: 02/23/2011

Hope that helps!

Converting MySQL DATETIME to System.DateTime

4 Answers4