select datepart(yy,date)*1000+datepart(y,date) as day_date,date,sum(save_money) from save_log group by day_date
很简单: select convert(datetime,convert(varchar(30),date,111)) date, sum(save_money) from save_log group by convert(datetime,convert(varchar(30),date,111))
SELECT CONVERT(Char(10), date, 112) AS Expr1, SUM(save_money) AS Expr2 FROM save_log GROUP BY CONVERT(Char(10), date, 112)
select convert(varchar,[date],101),sum(save_money) from save_log group by convert(varchar,[date],101)
select convert(datetime,convert(varchar(30),date,111)) date,
sum(save_money)
from save_log
group by convert(datetime,convert(varchar(30),date,111))
FROM save_log GROUP BY CONVERT(Char(10), date, 112)