Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Comments
-
Plz check if this helps: select JOB_ID,REPORT_URL,OWNER,USER_JOB_NAME,BURSTING,START_DATE,END_DATE from FUSION_BIPLATFORM.XMLP_SCHED_JOB WHERE TO_CHAR(END_DATE,'YYYY-MM-DD') > '2019-05-24' AND TO_CHAR(END_DATE,'YYYY-MM-DD') < '2021-12-01' order by end_date desc;