使用DataTable.RowFilter按日期过滤，而忽略时间 [英] Filtering by date with DataTable.RowFilter while ignoring time

问题描述

如何过滤特定日期的DataTable记录?

How do I filter for records on a DataTable which are on a certain date?

我尝试过普通的 [datecol] =#11 March 2010#和 CONVERT([datecol]，'System.DateTime')=#11 March 2010#.没有运气.

I've tried plain [datecol] = #11 March 2010# and CONVERT([datecol],'System.DateTime') = #11 March 2010#. With no luck.

MSDN:RowFilter表达式语法

[datecol] >= #11 March 2010 00:00# AND [datecol] <= #11 March 2010 23:59:59#

推荐答案

select 
   ...
   ...
   ...

where [datecol] between '11 March 2010 00:00:00' and '11 March 2010 23:59:59'

对不起，错了.刚写了很多SQL !!

Sorry, wrong head on. Just been writing a LOT of SQL!!

尝试一下

[datecol] >= #03/11/2010 00:00:00# AND [datecol] <= #03/11/2010 23:59:59# 

或

 [datecol] >= '03/11/2010 00:00:00' AND [datecol] <= '03/11/2010 23:59:59' 

这篇关于使用DataTable.RowFilter按日期过滤，而忽略时间的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！