Re: What changed with MySqlDbType.Datetime?

[Chris Cline]

Reggie,

Here is an alternative way of validating DateTime for the MySqlDateTime.Seralize()
This check the value in the even the time has been removed from the datetime which is a possiabilty if the user is working with a control that formats the DateTime to a ShortDate().

if (value is MySqlDateTime)
value = (value as MySqlDateTime).GetDateTime();
//
// if (! (value is DateTime))
// throw new MySqlException( "Only DateTime objects can be serialized by MySqlDateTime" );
DateTime dtValue;
try
{
System.Globalization.DateTimeFormatInfo mDate = new System.Globalization.DateTimeFormatInfo();
dtfi.ShortDatePattern = "M/d/yyyy";
dtValue = DateTime.ParseExact( value.ToString(), "d", mDate );
}
catch(Exception)
{
throw new MySqlException( "Only DateTime objects can be serialized by MySqlDateTime" );
}