I was trying to convert the sqlserver query to oracle and found a function which is not available in ora, could you plz help me in converting this
select top 5 ssm.maturity,datepart(mm, dateadd(mm, -3, ssm.maturity)) from sec_ind_ss ssm;
2014-10-23 00:00:00.0 7
9999-12-31 00:00:00.0 9
2021-01-02 00:00:00.0 10
2022-07-31 00:00:00.0 4
2019-07-31 00:00:00.0 4
I tried this but no result
SELECT ssm.maturity ,CAST(EXTRACT(MONTH FROM ssm.maturity - NUMTOYMINTERVAL(3,'month')) AS VARCHAR2(30))
from sec_ind_ss ssm WHERE ROWNUM<=5;