查询连个时间段内的数据

[CloudOfFly]

select * from UserManager.View_SearchOperator
where Convert(varchar(10),mdate) between '2008-10-13' and '2008-11-20'

我这样怎么查询不出来啊
mdate 是一个datetime类型的

[--小F--]

--try
select * from UserManager.View_SearchOperator
where Convert(varchar(10),mdate,120) between '2008-10-13' and '2008-11-20'

[百年树人]

select * from UserManager.View_SearchOperator
where Convert(varchar(10),mdate,120) between '2008-10-13' and '2008-11-20'

[华夏小卒]

select * from UserManager.View_SearchOperator
where  mdate  between '2008-10-13' and '2008-11-20'

这样应该就可以

[百年树人]

select Convert(varchar(10),getdate())
/**
           
---------- 
11  3 2009

（所影响的行数为 1 行）
**/

select Convert(varchar(10),getdate(),120)
/**
           
---------- 
2009-11-03

（所影响的行数为 1 行）
**/