mysql DATE_FORMAT的用法

遇到个业务要求 要求查询会员每日充值的信息

date表中目前有这三条数据
执行sql

SELECT DATE_FORMAT(date,'%Y-%m-%d') as everyday,sum(money) as totalmoney FROM `date` GROUP BY everyday;

如果要找出每个uid每天的money总和

SELECT DATE_FORMAT(date,'%Y-%m-%d') as everyday,sum(money) as totalmoney,uid FROM `date` GROUP BY everyday,uid;

如果时间是时间戳格式的话

SELECT DATE_FORMAT(from_unixtime(date),'%Y-%m-%d') as everyday,sum(money) as totalmoney,uid FROM `date` GROUP BY everyday,uid;

运行结果

mysql时间转时间戳
unix_timestamp
时间戳转为时间
from_unixtime