select * from hzbq where datediff(day,'2004-10-26',ryrq)=0
select * from hzbq where convert( varchar(10),ryrq, 120 ) = '2004-10-26'或select * from hzbq where datediff(day,ryrq,'2004-10-26') = 0
select * from hzbq where convert( varchar(10),ryrq, 120 ) = '2004-10-26'或select * from hzbq where datediff(day,ryrq,'2004-10-26') = 0
datatime类型的字段包含了时间,所以查询不匹配
select * from hzbq where convert(varchar(10),ryrq,120)='2004-10-26'或者select * from hzbq where datediff(day,ryrq,cast('2004-10-26' as datetime))=0
同意楼上,先是统一日期类型,再比较 select * from hzbq where convert(varchar(10),ryrq,120)='2004-10-26'或者select * from hzbq where datediff(day,ryrq,cast('2004-10-26' as datetime))=0
select * from hzbq where convert(varchar(10),ryrq,120)='2004-10-26'或者select * from hzbq where datediff(day,ryrq,cast('2004-10-26' as datetime))=0