摘要： -- 按天统计SELECT date_format(send_time,'%Y-%m-%d') as date FROM 表 ORDER BY date;-- 按周统计SELECT date_format(send_time,'%Y-%u') as date FROM 表 ORDER BY date 阅读全文