使用c#将日期插入MySql

string connectionString = "server=数据库服务器地址;user id=用户名;password=密码;database=数据库名;";
MySqlConnection connection = new MySqlConnection(connectionString);

connection.Open();

DateTime currentDate = DateTime.Now;
string insertQuery = "INSERT INTO 表名 (日期列名) VALUES (@date)";
MySqlCommand command = new MySqlCommand(insertQuery, connection);
command.Parameters.AddWithValue("@date", currentDate);

command.ExecuteNonQuery();

connection.Close();