34,587
社区成员
发帖
与我相关
我的任务
分享
select date from table where covert(nvarchar(10),date,120)='2008-02-03'
select date from table where date=convert(varchar(10),cast('2008-2-3' as datetime),120)
select date from table where date=convert(varchar(10),'2008-2-3',120)
如果你的字段中值存的有时分秒,只比较日,那么
select date from table where datediff(dd,date,'2008-2-3')=0