select * from customer c where TRUNC (TO_DATE(c.create_time,'yyyy-mm-dd hh24:mi:ss')) >
add_months(to_date('20130216','yyyy-mm-dd'),-6);
oracle查询最近6个月记录
最新推荐文章于 2022-09-08 10:48:48 发布
select * from customer c where TRUNC (TO_DATE(c.create_time,'yyyy-mm-dd hh24:mi:ss')) >
add_months(to_date('20130216','yyyy-mm-dd'),-6);