RowFilter日期筛选请问~

RowFilter日期筛选请教~！
数据字段类型是“yyyy-MM-dd HH:mm:ss”我想筛选出日期从DAY1天到DAY2天，并且时间在TIME1到TIME2之间的所有数据
例：日期是从2012-04-01至2012-04-10并且时间为08:00:00至09:00:00 的所有数据。请问RowFilter的筛选语句如何写？

[解决办法]

C# code

create table testDate( ID int primary key identity(1,1), DateLoan datetime)insert into testDate values('2012-4-27 07:20:10')insert into testDate values('2012-4-28 07:20:10')insert into testDate values('2012-4-28 08:20:10')insert into testDate values('2012-4-28 08:30:10')insert into testDate values('2012-4-28 08:40:10')insert into testDate values('2012-4-28 08:50:10')insert into testDate values('2012-4-28 09:00:00')insert into testDate values('2012-4-28 09:20:10')insert into testDate values('2012-4-28 09:20:10')SELECT * FROM testDate/*ID          DateLoan----------- -----------------------1           2012-04-28 07:20:10.0002           2012-04-28 08:20:10.0003           2012-04-28 08:30:10.0004           2012-04-28 08:40:10.0005           2012-04-28 08:50:10.0006           2012-04-28 09:00:00.0007           2012-04-28 09:20:10.0008           2012-04-28 09:20:10.0009           2012-04-27 07:20:10.000(9 行受影响)*/SELECT * FROM testDate WHERE SUBSTRING(CONVERT(NVARCHAR(20),DateLoan,120),1,10) between '2012-04-27' and '2012-04-28' and SUBSTRING(CONVERT(NVARCHAR(20),DateLoan,114),1,8) between '08:00:00' and '09:00:00' /*ID          DateLoan----------- -----------------------2           2012-04-28 08:20:10.0003           2012-04-28 08:30:10.0004           2012-04-28 08:40:10.0005           2012-04-28 08:50:10.0006           2012-04-28 09:00:00.000(5 行受影响)*/
[解决办法]
 好纠结的人儿。。。
  SQL能处理的问题 非要搬到代码里面去执行
  按照你这需求 还不如弄个存储过程