Wednesday, February 8, 2017

month first and last date

select to_char(trunc(sysdate ,'Month'),'dd/mm/rr') into :sdt from dual;
select to_char(last_day(sysdate ),'dd/mm/rr') into :edt from dual;


No comments:

Post a Comment

To generate a PDF using JavaScript in Oracle APEX from a collection

  To generate a PDF using JavaScript in Oracle APEX from a collection, you can follow these steps: 1. Create a button or link on your APEX p...