A reader, April 27, 2019 - 11:40 am UTC
SELECT "NUMBER" ,current_phase ,orig_operator,orig_date_entered,requestedDate,close_time ,approval_status,affected_item,assets ,brief_description,category,zproduct_type,assign_dept,coordinator,requested_by,zpriority,zsupport_dept FROM HPSMPROD.CM3RM1 WHERE ORIG_DATE_ENTERED BETWEEN LAST_DAY(ADD_MONTHS(SYSDATE, -2)) + 1 AND LAST_DAY(ADD_MONTHS(SYSDATE, -1)) order by orig_date_entered ASC;
A reader, March 10, 2020 - 1:14 pm UTC