34,590
社区成员
发帖
与我相关
我的任务
分享
select * from
table
where
datediff(minute,[time],cast((Convert(varchar(10),getdate(),120)+' 00:00:00')as datetime))<=0
ANd
datediff(minute,[time],cast((Convert(varchar(10),getdate(),120)+' 23:59:59')as datetime))>=0
select * from table where datediff(dd,time,getdate()) = 0
select * from table
where datediff(day,[time],getdate())
select * from table where datediff(dd , time , getdate()) = 0
select * from table where convert(varchar(10),time,120) = convert(varchar(10),getdate(),120)