按日分组：select DATE_FORMAT(o.OrderDate,"%Y%m%d") weeks,count(*) count from orders o group by weeks;
按月分组：select DATE_FORMAT(o.OrderDate,"%Y%m") weeks,count(*) count from orders o
知识关键词：DATE_FORMAT
SELECT DATE_FORMAT(created_date,"%Y-%m-%d") as time,sum(money) money FROM o_finance_detail where org_id = 1000 GROUP BY time
SELECT DATE_FORMAT(created_date,"%Y-
