private void Bug32595_Click(object sender, EventArgs e) { MySqlConnection conn = new MySqlConnection(); MySqlDataReader dr; conn.ConnectionString = "DataSource=localhost;Database=test;UserID=root;Password=******;PORT=3306;Allow Zero Datetime=True;logging=True;"; conn.Open(); MySqlCommand command = new MySqlCommand(); command.Connection = conn; MySqlCommand cmdCreateTable = new MySqlCommand("DROP TABLE IF EXISTS `test`.`bug32595`", conn); cmdCreateTable.CommandType = CommandType.Text; cmdCreateTable.CommandTimeout = 0; cmdCreateTable.ExecuteNonQuery(); cmdCreateTable.CommandText = "CREATE TABLE `test`.`bug32595` (" + "`ID` int unsigned NOT NULL AUTO_INCREMENT, " + "`LastModified` varchar(50) NOT NULL DEFAULT '', " + "PRIMARY KEY (`ID`) " + ") DEFAULT CHARSET=latin1;"; cmdCreateTable.ExecuteNonQuery(); DateTime dt; dt = DateTime.Now; cmdCreateTable.CommandText = "INSERT INTO bug32595 VALUES (NULL,'" + dt.ToString("yyyy-MM-dd HH:mm:ss") + "')"; try { Assert.AreEqual(1, cmdCreateTable.ExecuteNonQuery()); Console.WriteLine("dt is now: " + dt.ToString("yyyy-MM-dd HH:mm:ss")); MessageBox.Show("Wait a bit"); dt = DateTime.Now; cmdCreateTable.CommandText = "UPDATE bug32595 SET LastModified = '" + dt.ToString("yyyy-MM-dd HH:mm:ss")+"'"; Assert.AreEqual(1, cmdCreateTable.ExecuteNonQuery()); Console.WriteLine("dt is now: " + dt.ToString("yyyy-MM-dd HH:mm:ss")); cmdCreateTable.CommandText = "SELECT * FROM bug32595"; dr = cmdCreateTable.ExecuteReader(); while (dr.Read()) { Console.WriteLine(dr.GetDataTypeName(1)); Console.WriteLine(dr.GetFieldType(1)); Console.WriteLine(dr.GetValue(1).GetType().FullName); dt = dr.GetDateTime(1); Console.WriteLine("dt is finally: " + dt.ToString("yyyy-MM-dd HH:mm:ss")); } dr.Close(); cmdCreateTable.Dispose(); conn.Close(); } catch (Exception ex) { Assert.Fail(ex.Message); } }