datetime怎么做月份查询

[kvkensinb]

我表的数据如下：
日期 销售量
2010-7-13 1000
2010-8-3 1300
2010-8-26 800
2010-10-19 2300
用户会输入月份范围，如：2010-7到2010-9，SELECT 日期,销售量
FROM table where (日期>='2010-7' and 日期<='2010-9')但由于查询时候会提示从字符串转换为 datetime 时发生语法错误。请高手帮帮忙，谢谢

[xuam]

convert (char(7),日期,120)

[lcqtgb]

select 1 from tb where datepart(yyyy,dates) between '2009' and '2010'

[FlySQL]

SELECT 日期,销售量  
FROM table where convert(varchar(7),日期,120)>='2010-07' and convert(varchar(7),日期,120<='2010-09'

[sql_cctv]

where 日期>='2010-7-1' and 日期<'2010-10-1'

[FlySQL]

SELECT 日期,销售量  
FROM table where convert(varchar(7),日期,120)>='2010-07' and convert(varchar(7),日期,120)<='2010-09'

[dawugui]

select * from tb where convert(varchar(7),日期,120) between '2010-07' and '2010-09'

[chuanzhang5687]

create table a
(
time1 datetime,
num varchar(10)
)
insert into a values('2010-7-13','1000')
insert into a values('2010-8-3','1300')
insert into a values('2010-8-26','800')
insert into a values('2010-10-19','2300')
select * from a
select * from a where time1 between '2010-7-1' and '2010-9-30'

[fpzgm]

--直接
cast(日期 as date) between '2010-7-1' and '2010-9-30'

[zhangsuyunpk521]

[Quote=引用 8 楼 fpzgm 的回复:]
SQL code

--直接
cast(日期 as date) between '2010-7-1' and '2010-9-30'
[/Quote]
up

[coleling]

--设用户输入的查询参数为@beginmonth和@endmonth，类型为字符串，格式为"2010-7"
DECLARE @sdate datetime, @edate datetime
SET @sdate = cast(@beginmonth+'-1' as datetime)
SET @edate = dateadd(d,-1,dateadd(m,1,cast(@endmonth+'-1' as datetime)))

查询的时候用FROM table where (日期>=@sdate and 日期<=@edate)