求问阿！我下面的句子有什么不对？？

[red_wolf]

select Y_type,SUM(Y_RMB) as a from admin_yewu where Y_time<2001-8-8 and Y_time>2004-6-8 group by Y_type

数据库中Y_time字段是datetime类型

如果不对！要怎么写啊？？
急急急！

[zjcxc]

--日期要用'括起来

select Y_type,SUM(Y_RMB) as a from admin_yewu where Y_time<'2001-8-8' and Y_time>'2004-6-8' group by Y_type

[lb_panda]

select Y_type,SUM(Y_RMB) as a from admin_yewu where Y_time between '2001-8-8' and '2004-6-8' group by Y_type

[loverpyh]

select Y_type,SUM(Y_RMB) as a from admin_yewu where convert(char(10),Y_time,120)<'2001-08-08' and convert(char(10),Y_time,120)>'2004-06-08' group by Y_type

[xiyang2170]

Select Y_type,SUM(Y_RMB) as a
From admin_yewu
Where Y_time<'2001-8-8' and Y_time>'2004-6-8'
Group by Y_type

[start1127]

日期用单引号括起来

[pzr]

Select Y_type,SUM(Y_RMB) as a
From admin_yewu
Where Y_time<'2001-8-8' and Y_time>'2004-6-8'
Group by Y_type
日期用单引号括起来

[yingshis]

注意日期用‘’括起来。
select Y_type,SUM(Y_RMB) as a from admin_yewu where Y_time between '2001-8-8' and '2004-6-8' group by Y_type

[lzymagi]

你可以用>'20040608'

[red_wolf]

为什么没有人理我啊！