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

结果:

 

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