如何从C#在PostgreSQL中插入DateTime值

using Npgsql;

string connectionString = "Server=your_server_address;Database=your_database_name;User Id=your_username;Password=your_password;";
NpgsqlConnection connection = new NpgsqlConnection(connectionString);

connection.Open();

DateTime dateTimeValue = DateTime.Now; // 或者你可以使用其他 DateTime 值
string insertQuery = "INSERT INTO your_table_name (column_name) VALUES (@dateTimeValue)";
NpgsqlCommand command = new NpgsqlCommand(insertQuery, connection);
command.Parameters.AddWithValue("dateTimeValue", dateTimeValue);

command.ExecuteNonQuery();

connection.Close();