select * from emp
where to_char(hiredate,'mm')=to_char(add_months( sysdate,2),'mm');

结果:

 

posted on 2016-09-23 15:23  风吹羽  阅读(174)  评论(0编辑  收藏  举报