Dapper query with DateTime

Question

I'm trying to use Dapper to query a table from my ODBC driver. The specific query I'm trying to run needs to return rows that have a DateTime value greater than the passed parameter to the query.

This is what I have tried:

string delta = "05/02/2019 08:41:37";
DateTime deltaDt = DateTime.Parse(delta);

using (IDbConnection connection = new OdbcConnection(/**Connection string**/))
{
    connection.Open();

    try
    {
        string query = "SELECT * FROM MyTable WHERE Date > @Delta";
        IEnumerable<object> records = connection.Query<object>(query, new { Delta = deltaDt });

        Console.WriteLine(records.Count());
    }
    catch (Exception ex)
    {
        Console.WriteLine(ex.Message);
    }
}

However, with the above I get the following error:

{"ERROR [22018] Cannot convert non-numeric data"}

I then tried using IDBConnection without Dapper to see if I was just doing something incorrect, however the query works fine if I just do the following:

string delta = "05/02/2019 08:41:37";
DateTime deltaDt = DateTime.Parse(delta);

using (IDbConnection connection = new OdbcConnection(/**Connection string**/))
{
    connection.Open();

    string odbcQuery = "SELECT * FROM MyTable WHERE Date > ?";

    IDbCommand command = connection.CreateCommand();

    IDbDataParameter parameter = command.CreateParameter();
    parameter.Value = deltaDt;
    command.Parameters.Add(parameter);

    command.CommandText = odbcQuery;
    System.Data.IDataReader reader = command.ExecuteReader();
    while (reader.Read())
    {
        object[] values = new object[1];
        reader.GetValues(values);
        console.log(values);
    }
}

Am I doing something wrong when binding the DateTime using the Dapper query? As far as I can see the value is the same whether I use Dapper query or IDbDataParameter. I have also tried the following, but still get the same issue:

string query = "SELECT * FROM MyTable WHERE Date > @Delta";
DynamicParameters dp = new DynamicParameters();
dp.Add("@Delta", deltaDt, DbType.DateTime);
IEnumerable<object> records = connection.Query<object>(query, dp);

Answer 1

Try in this way:

SELECT * FROM MyTable WHERE Date > ?Delta?

then

 IEnumerable<object> records = connection.Query<object>(query, new { Delta = deltaDt });