--没有date这种类型,要实现这种类型的结果可以
select Convert(char(10),adatetime,120),cn=count(item_guid)
from mytable
group by Convert(char(10),adatetime,120)
select Convert(char(10),adatetime,120),cn=count(item_guid)
from mytable
group by Convert(char(10),adatetime,120)
,count(item_guid)
from mytable
group by cast(adatetime as datetime)
date只有日期,比如2005-10-1group by 中如果用表中的某个字段没问题,如果用表达式报错了!
from (select cast(adatetime as date) as date1, item_guid
from mytable )a
group by date1