@anirudhs wrote: the macro variable auth_st_dt = intnx('Month',today(), -1,'b'); auth_end_dt= intnx('Month',today(), -1,'e'); call symput ('auth_st_dt' , "'" || put(auth_st_dt, date9.) || ":00:00:00'"); call symput ('auth_end_dt', "'" || put(auth_end_dt, date9.) || ":23:59:59'");
So you are creating macro variables that have in them strings in the style generated by the DATETIME format that are enclosed in single quotes.
%let auth_st_dt = '08APR2022:00:00:00' ;
%let auth_end_dt = '30APR2022:23:59:59';
Then in the ORACLE code you inserting that string. So to ORACLE that looks like a string constant.
Is the field in ORACLE a DATE or a TIMESTAMP?
... View more