求一个求和的SQL语句？？？

Question

 Tb_AAAA
   id        counts           shijian
   1           5           2008-07-07 12:25:28
   2           6           2008-07-06 16:25:11
   3           7           2008-07-07 12:25:21 
   4           8           2008-07-05 11:25:26
   5           3           2008-07-05 17:15:21
   6           9           2008-07-03 09:25:25 现在我要的到按天数求和
得到如下类似的样式
    Counts             shijian
      9               2008-07-03 
      11              2008-07-05  
      6               2008-07-06 
      12              2008-07-07 

Answer 1

select  shijian ,sum(counts)
from Tb_AAAA 
group by shijian 

Answer 2

select Counts=sum(Counts),shijian=(convert(char(10),shijian,120))
from Tb_AAAA
group by (convert(char(10),shijian,120))

Answer 3

select  convert(varchar(10),shijian,120) ,sum(counts) 
from Tb_AAAA 
group by convert(varchar(10),shijian,120)

Answer 4

select  convert(varchar(10),shijian,120) ,sum(counts) 
from Tb_AAAA 
group by convert(varchar(10),shijian,120)
明白了,嘿嘿,共同进步

Answer 5

没注意是datetime型，2，3楼都是正解

Answer 6

select Counts=sum(Counts),shijian=(convert(char(10),shijian,120)) 
from Tb_AAAA 
group by (convert(char(10),shijian,120))