select * from tb where cast(rtrim(dtime) as datetime) between '2010-4-1' and '2010-4-18'
select * from tb where convert(datetime,dtime,120) between '2004-4-1' and '2010-4-18'
--如果你的dtime列保存的是如下的标准格式(单号月,日都补上了0):'2010-04-01' , '2010-04-18' select * from tb where DTIME between '2010-04-01' and '2010-04-18'--否则,建议用如下的语句: select * from tb where cast(DTIME as datetime) between '2010-04-01' and '2010-04-18'
select * from tb where convert(datetime,dtime,120) between '2004-4-1' and '2010-4-18'
select * from tb where DTIME between '2010-04-01' and '2010-04-18'--否则,建议用如下的语句:
select * from tb where cast(DTIME as datetime) between '2010-04-01' and '2010-04-18'