For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
Hello I am trying to pick previous six months from any given day.
SELECTÂ add_months(trunc(to_date(20200615,'yyyymmdd'),'MM'),-6) FROM dual
But this query only giving me first date of previous 6 months.
What I want is 2019/12/15 from this query.