select * from 表名 where Datediff(minute,cast(convert(varchar,getdate(),23)+ ' 10:01:00' as datetime),senddate) <0 and Datediff(minute,cast(convert(varchar,getdate(),23)+ ' 09:59:00' as datetime),senddate)>0
select * from 表名 where Datediff(minute,cast(left(getdate(),10)+ ' 10:01:00' as datetime),senddate) <0 and Datediff(minute,cast(dateadd(day,-1,left(getdate(),10)+ ' 09:59:00')as datetime),senddate)>0
from 表名
where Datediff(minute,cast(convert(varchar,getdate(),23)+ ' 10:01:00' as datetime),senddate) <0
and Datediff(minute,cast(convert(varchar,getdate(),23)+ ' 09:59:00' as datetime),senddate)>0
convert(datetime,'4/24/2009 10:25:00 AM',101)
select convert(datetime,'4/5/2009 10:25:00 AM',101)
/*
2009-04-05 10:25:00.000
*/
select convert(datetime,'4/5/2009 10:25:00 AM',103)
/*
2009-05-04 10:25:00.000
*/
select DATEDIFF(MI,'4/24/2009 10:25:00 AM' ,GETDATE())