在dategridview中筛选日期时截断日期

我在试着过滤 DataGridView DataTable 来源 by using 日期计时器选取器`

我的问题是那个专栏 DATETIME 有日期和时间,我只想使用没有时间的日期示例

select cast(DATETIME as DATE) from table_name

表达式包含未定义的函数call cast()

那我怎么才能把日期截短呢?

(MyDataGridView.DataSource as DataTable).DefaultView.RowFilter = string.Format("cast(DATETIME as DATE)= '{0}'", DpickerEntryDate.Value.ToShortDateString());

所有事件代码

        if (DpickerEntryDate.Value.Date <= DateTime.Today.Date)
        {
            (MyDataGridView.DataSource as DataTable).DefaultView.RowFilter = string.Format("cast(DATETIME as DATE) = '{0}'", DpickerEntryDate.Value.ToShortDateString());
        }
        else if (DpickerEntryDate.Value.Date > DateTime.Today.Date)
        {
            MessageBox.Show("Can not use future date", "Message", MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1, MessageBoxOptions.RtlReading);
        }
        else
        {
            //do something
        }

谢谢