34,575
社区成员
发帖
与我相关
我的任务
分享
select * from Client_Table where cast(InputDate as datetime)=getdate()-1
select * from Client_Table where datediff(dd,cast(InputDate as datetime),getdate()) <=1
select * from Client_Table where datediff(dd,InputDate,getdate()) <=1
select * from Client_Table where convert(varchar(10),InputDate,120) = '2009-11-21'