1.date_format(`字段名`,'格式'): 日期截取 例:查询统计JTDXQ通道每日成功的金额,按日分组并按日期倒序排列 SELECT date_format(`cron_time`,'%Y-%m-%d') as date, SUM(`money`) FROM ecs_w_zh_cronlist_log WHERE `status` = 1 AND is_big = 'JTDXQ' GROUP BY date ORDER BY date DESC