CODEWITHSUNDEEP
c#sqlpostgresqldatenpgsql
Brezhnews
Brezhnews

Reputation: 355

What is the Date type in npgsql?

I am using postgreSQL database. I need to add "Date" parametres with SQL query. What do I have to write where I wrote in the code "XXX" Here is the source code:

NpgsqlCommand RupCmd = new NpgsqlCommand("UPDATE TABLE SET dat1=@dno,dat2=@dlidz,id_viesis=@idv,id_istaba=@idi WHERE rezervacijas_id=@id", con);
RupCmd.Parameters.Add(new NpgsqlParameter("@dno", NpgsqlTypes.NpgsqlDbType.Date, XXX, "dat1"));
RupCmd.Parameters.Add(new NpgsqlParameter("@dlidz", NpgsqlTypes.NpgsqlDbType.Date, XXX, "dat2"));
RupCmd.Parameters.Add(new NpgsqlParameter("@idv", NpgsqlTypes.NpgsqlDbType.Integer, sizeof(int), "id_viesis"));
RupCmd.Parameters.Add(new NpgsqlParameter("@idi", NpgsqlTypes.NpgsqlDbType.Integer, sizeof(int), "id_istaba"));
RupCmd.Parameters.Add(new NpgsqlParameter("@id", NpgsqlTypes.NpgsqlDbType.Integer, sizeof(int), "rezervacijas_id"));

Upvotes: 1

Views: 3401

Answers (1)

Michael Buen
Michael Buen

Reputation: 39433

You can leave it with zero, i.e.

RupCmd.Parameters.Add(
     new NpgsqlParameter("@dno", NpgsqlTypes.NpgsqlDbType.Date, 0, "dat1"));

Upvotes: 1

Related Questions