Несоответствие типов в запросе с полем Date/Time

OleDbDataAdapter adapter = new OleDbDataAdapter("SELECT * FROM sob where data =  '" + DateTime.Now + "'   ", connection);

            OleDbConnection connection = new OleDbConnection(connectionString);
           
            OleDbDataAdapter adapter = new OleDbDataAdapter("SELECT * FROM sob ", connection);
 
            OleDbCommand command = new OleDbCommand("SELECT * FROM sob WHERE data = @DT", connection);
            command.Parameters.Add("@DT", OleDbType.Date,0,"Date");
            adapter = new OleDbDataAdapter(command);
            connection.Open();
            command.Parametres["@DT"].Value = DateTime.Now.Date;
            adapter.Fill(dataSet,"sob");
            connection.Close();

OleDbConnection connection = new OleDbConnection(connectionString);
OleDbCommand command = new OleDbCommand("SELECT * FROM sob WHERE data = @DT", connection);
command.Parameters.Add("@DT", OleDbType.Date,0,"Date");
command.Parametres["@DT"].Value = DateTime.Now.Date;
adapter.Fill(dataSet,"sob");

"SELECT * FROM dbName WHERE CDate(s_datetime) BETWEEN @dtBegin AND @dtEnd";
cmd.Parameters.Add(new OleDbParameter("dtBegin", OleDbType.Date) { Value = dtBegin });
cmd.Parameters.Add(new OleDbParameter("dtEnd", OleDbType.Date) { Value = dtEnd });

cmd.Parameters.Add(new OleDbParameter("dtBegin", OleDbType.Date, 0, "Date") { Value = dtBegin });
cmd.Parameters.Add(new OleDbParameter("dtEnd", OleDbType.Date, 0, "Date") { Value = dtEnd });

string dtBegin = new DateTime(2020, 01, 20, 0, 0, 0).ToString("dd.MM.yyyy HH:mm:ss");
string dtEnd = new DateTime(2020, 01, 20, 23, 59, 59).ToString("dd.MM.yyyy HH:mm:ss");