如何使用C#在Oracle关系数据库中插入日期

using System;
using Oracle.ManagedDataAccess.Client;

class Program
{
    static void Main(string[] args)
    {
        string connectionString = "User Id=your_username;Password=your_password;Data Source=your_data_source";

        using (OracleConnection connection = new OracleConnection(connectionString))
        {
            connection.Open();

            // 创建一个Oracle命令对象
            using (OracleCommand command = new OracleCommand())
            {
                command.Connection = connection;
                command.CommandText = "INSERT INTO your_table_name (column_name) VALUES (:date_value)";

                // 添加参数
                OracleParameter parameter = new OracleParameter("date_value", OracleDbType.Date);
                parameter.Value = DateTime.Now; // 将当前日期插入到数据库
                command.Parameters.Add(parameter);

                // 执行命令
                int rowsAffected = command.ExecuteNonQuery();
                Console.WriteLine($"{rowsAffected} rows inserted.");
            }
        }
    }
}