select * from table_name where trunc(日期字段)=to_date('2018-05-20','yyyy-mm-dd');
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')