按月份查询
SELECT * FROM tbl_order GROUP BY DATE_FORMAT(CreateTime,'%Y-%m');
SELECT sum(money), DATE_FORMAT(CreateTime,'%Y-%m') FROM tbl_order GROUP BY DATE_FORMAT(CreateTime,'%Y-%m');
按天查询
SELECT * FROM tbl_bill GROUP BY DATE_FORMAT(CreateTime,'%Y-%m-%d');
SELECT sum(Income), DATE_FORMAT(CreateTime,'%Y-%m-%d') FROM tbl_bill GROUP BY DATE_FORMAT(CreateTime,'%Y-%m-%d');