数据库中保存的交易记录,需要按天和按小时分别展现出来,可使用sql语句直接分组
select count(*) as '交易数量', sum(amount) as '交易总额' FROM transaction
where has_deal=1 group by DATE_FORMAT( send_erc_timestamp, "%Y-%m-%d %H" );
数据库中保存的交易记录,需要按天和按小时分别展现出来,可使用sql语句直接分组
select count(*) as '交易数量', sum(amount) as '交易总额' FROM transaction
where has_deal=1 group by DATE_FORMAT( send_erc_timestamp, "%Y-%m-%d %H" );