求大神帮转换成ORACLE语句

select * from table e where datediff(dd,getdate(),dateadd(yy,case  

                                        when ISNULL(e.GENDER,0)=1  then 60 

                                        when ISNULL(e.GENDER,0)=2  then 55 end,e.BirthDay)) between 0 and 40

mysql语句先写对