用convert（date）将datetime转成date然后直接比较。
select * from table where adate
你就转下不行吗？where CONVERT(varchar(100), adate, 25) between CONVERT(varchar(100), bdate, 25) and CONVERT(varchar(100), cdate, 25)
