24小时内充值总数

SELECT sum(amount)/100000000 as '24小时内充值总数',count(user_id) as '24小时内充值人数'
FROM management.t_wallet_transaction_history
WHERE transaction_type =1 
and date_format(FROM_UNIXTIME(`operate_time`/1000),'%Y-%m-%d %H:%m:%s')>=(NOW() - interval 24 hour)

7.15更改后

SELECT sum(amount)/100000000 as '24小时内充值总数',count(user_id) as '24小时内充值人数'
FROM management.t_deposit
where op_time>=(NOW() - interval 24 hour)

tips：
换了表 t_deposit
时间戳
语雀内容