cast(UNIX_TIMESTAMP(DATE_FORMAT(create_time, '%Y-%m-%d')) * 1000 AS UNSIGNED) AS `time`, sum(money) as totalCash, count(id) as totalNum
GROUP BY `time`
按小时
'%Y-%m-%d %H:00:00'
按分钟
'%Y-%m-%d %H:%m:00'
按秒
'%Y-%m-%d %H:%m:%s'
cast(UNIX_TIMESTAMP(DATE_FORMAT(create_time, '%Y-%m-%d')) * 1000 AS UNSIGNED) AS `time`, sum(money) as totalCash, count(id) as totalNum
GROUP BY `time`
按小时
'%Y-%m-%d %H:00:00'
按分钟
'%Y-%m-%d %H:%m:00'
按秒
'%Y-%m-%d %H:%m:%s'