peoplecode last day of month

peoplecode last day of month

peoplecode last day of month using function last_day of sql and using sqlexec of peoplecode for select last day of month

Using SQL

select last_day(add_months((sysdate),0)) from dual;

Using Peoplecode

Sqlexec(“select last_day(add_months((sysdate),0)) from dual”,&last_day_of_month);