SQL SERVER 的GROUP BY问题

[xiankehu]

在SQL SERVER 中对DATETIME的数据进行GROUP BY,要求
只对DATE,而不对TIME.
EXAMPLE:
A B C
A1 2 2001/10/08 01:01:01
A1 3 2001/10/08 01:01:01
A1 4 2001/10/08 01:01:01
A1 6 2001/10/08 02:02:02
在GROUP BY 之后结果为
A1 15 2001/10/08
而不是
A1 9 2001/10/08 01:01:01
A1 6 2001/10/08 02:02:02

[wwl007]

没有画了

[icevi]

好象以前有人提过
select a,sum(b) as b ,cast(cast( c as int) as datetime) as c
from tablename
group by a,cast(cast( c as int) as datetime)

[IUNKNOWN_COM]

ok

[LUJUN]

select a,convert(char(10),c,120) as c, sum(b) as b from table1 group by a,convert(char(10),c,120)