按天分组统计金额和数量

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'