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-%m’) as time,sum(money) money FROM o_finance_detail where org_id = 1000 GROUP BY time
SELECT DATE_FORMAT(created_date,‘%Y’) as time,sum(money) money FROM o_finance_detail where org_id = 1000 GROUP BY time
SELECT DATE_FORMAT(created_date,‘%Y-%u’) as time,sum(money) money FROM o_finance_detail where org_id = 1000 GROUP BY time