在SQL语句中怎样查询出当年当月的数据?

[hmz998]

在SQL语句中怎样查询出当年当月的数据?我用的是SQL server数据库,表ordered 中有一日期字段srrq,我想统计当年当月的数据,SELECT 语句该怎样写
sql="Select xh,sum(sl) from rkd where year(jhrq)="&year(date())&" and month(jhrq)="&month(date()&" group by xh "为何不行,请高手指教!

[sun94510451]

year(jhrq)="&Cint(year(date()))&" and month(jhrq)="&Cint(month(date())&"
试试，不行的话，提前将关键字转换。

[micher_yan]

select * from table where jhrq between "2004-11-1 00:00:00" and "2004-12-1 00:00:00"
12月数据

[micher_yan]

sorry，11月数据

[fallback]

dim ytime,mtime
ytime = year(now())
mtime = month(now())

sql="Select xh,sum(sl) from rkd where year(jhrq)='"&ytime&"' and month(jhrq)='"&mtime&"'group by xh "

这样我可以

[zlj113]

sql="Select xh,sum(sl) from rkd where year(jhrq)='"&year(date())&"' and month(jhrq)='"&month(date()&"' group by xh


试下