oracle 查询某天的数据

原文链接：https://blog.csdn.net/zheng199172/article/details/82800781

select sum(amount)/100 ,count(1) from tbl_transaction_info 
    where trade_type=0
    and status = 2 
    and trade_time >=to_date('2018-10-11 00:00:00','yyyy-mm-dd hh24:mi:ss')
    and trade_time <=to_date('2018-10-12 23:00:00','yyyy-mm-dd hh24:mi:ss')

and to_char(a.fbizdate,'yyyy-mm-dd')
>=to_char(add_months(sysdate,-3),'yyyy-mm-dd')
and to_char(a.fbizdate,'yyyy-mm-dd')
<to_char(sysdate,'yyyy-mm-dd')
或者
and to_char(a.fbizdate,'yyyy-mm-dd')
>=to_char(sysdate-90,'yyyy-mm-dd')
and to_char(a.fbizdate,'yyyy-mm-dd')
<to_char(sysdate,'yyyy-mm-dd')