Hello, I am just running this simple code but DBA were telling me that I am using truncate function but I am not using it. That's what DBA is seeing in Oracle Database WHERE ( (TRUNC("PAID_DT") >=TO_DATE('01JAN2012','DDMONYYYY','NLS_DATE_LANGUAGE=American') ) AND ( ( ( (TRUNC("SVC_BGN_DT") BETWEEN TO_DATE('01JAN2012','DDMONYYYY','NLS_DATE_LANGUAGE=American') AND TO_DATE('31DEC2017','DDMONYYYY','NLS_DATE_LANGUAGE=American') ) OR (TRUNC("SVC_BGN_DT") BETWEEN TO_DATE('31DEC2017','DDMONYYYY','NLS_DATE_LANGUAGE=American') AND TO_DATE('01JAN2012','DDMONYYYY','NLS_DATE_LANGUAGE=American') ) ) ) ) What should I do in the code that oracle don't use the truncate function behind the scene. All the help will be appreciated. PROC SQL; CREATE TABLE work.Claims AS SELECT t1.TRNSCT_CNTL_NBR, t1.LINE_NBR, t1.MEDICAID_ID, t1.BILL_PRVDR_NPI FROM RADWPUB.Table WHERE t1.PAID_DT >= '1Jan2012'd AND t1.SVC_BGN_DT BETWEEN '1Jan2012'd AND '31Dec2017'd AND t1.BILL_PRVDR_NPI = '1013918960' AND t1.CR_CD = '0'; QUIT;
... View more