22,209
社区成员
发帖
与我相关
我的任务
分享
WHERE TO_CHAR(sktime,'YYYY-MM-DD') = '2010-08-19'
where convert(varchar(10),sktime,120)='2010-08-19'
--or
where datediff(dd,sktime,'2010-08-19')=0
select * from 表名 where datediff(dd,sktime,'2010-08-19')=0
--查询2010-08-19的数据
select * from TB where datediff(d,'2010-08-19',[sktime])=0