select convert(char(10),RECORDDT,120) as RECORDDT ,
sum(GAMECOUNT)as GAMECOUNT_sum ,sum(GAMETIME_H) as GAMETIME_H_sum
from tb_PlatformBaseData
where RECORDDT >='2011-11-28' and RECORDDT <='2011-12-01'
--where RECORDDT >='2011-11-28 0:00:00' and RECORDDT <='2011-12-01 23:59:59.999'
group by convert(char(10),RECORDDT,120)
sum(GAMECOUNT)as GAMECOUNT_sum ,sum(GAMETIME_H) as GAMETIME_H_sum
from tb_PlatformBaseData
where RECORDDT >='2011-11-28' and RECORDDT <='2011-12-01'
--where RECORDDT >='2011-11-28 0:00:00' and RECORDDT <='2011-12-01 23:59:59.999'
group by convert(char(10),RECORDDT,120)