SELECT DATE_FORMAT(c.create_time, '%m-%d') AS createTime1,u.name as name,IFNULL(SUM(c.price) ,0)AS rec
FROM table c
数据库日期格式化date_format
最新推荐文章于 2024-08-07 14:25:25 发布
SELECT DATE_FORMAT(c.create_time, '%m-%d') AS createTime1,u.name as name,IFNULL(SUM(c.price) ,0)AS rec
FROM table c