How to convert date format in order my condition w calculating work?
where dte_received BETWEEN SYSDATE AND add_months(sysdate,-12)
I took the following steps:
1. select SYSYDATE FROM duals (-> sysdate looks like 5/7/2018 12:02:11 pm
2. select dte_received FROM mytable (-> dte_received looks like 19981213)
How should i convert it in order my condition date formats match and statement work?
Thank you in advance!