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

[Jonatan Bouillon]

I finnaly understand that the new version of mysql is using tje getdatetime function instead of the GetReader().GetMySqlDateTime(ordinal).GetDateTime();

Instead of the GetReader().GetDateTime(ordinal);

The GetDateTime(ordinal) contains the _connection.Settings.ConvertZeroDateTime options that allow to convert date in format '0000-00-00' to .net DateTime.Min.

public override DateTime GetDateTime(int i)
{
IMySqlValue val = GetFieldValue(i, true);
MySqlDateTime dt;

if (val is MySqlDateTime)
dt = (MySqlDateTime)val;
else
{
// we need to do this because functions like date_add return string
string s = GetString(i);
dt = MySqlDateTime.Parse(s);
}

dt.TimezoneOffset = driver.timeZoneOffset;
if (_connection.Settings.ConvertZeroDateTime && !dt.IsValidDateTime)
return DateTime.MinValue;
else
return dt.GetDateTime();
}

Has an alternative I compile a new version of mysql with this call instead and it fixed my problem.