orcale没有datediff函数,可以使用trunc
查询前一天数据:
select * from customer_loan t where trunc(INS_DATE,'dd')=trunc(sysdate-1,'dd');
查询前七天数据:
select * from customer_loan t where trunc(INS_DATE,'dd')=trunc(sysdate-7,'dd');
查询前三十天数据:
select * from customer_loan t where trunc(INS_DATE,'dd')=trunc(sysdate-30,'dd');