Where RegDate Between '2005-3-1' And '2005-3-15'试一下
select * from table where regdate>='2005-3-1' and regdate<='2005-3-15'
---regdate为字符类型 select * from table where convert(datetime,regdate,120) between '2005-3-1' and '2005-3-15' ---regdate为时间类型 select * from table where regdate between '2005-3-1' and '2005-3-15'
select *
from table
where convert(datetime,regdate,120) between '2005-3-1' and '2005-3-15'
---regdate为时间类型
select *
from table
where regdate between '2005-3-1' and '2005-3-15'