Saturday, July 2, 2022

Date format

 select  ADD_MONTHS(TRUNC(SYSDATE,'MM'),-1), last_day(add_months(trunc(sysdate,'mm'),-1))-- , TRUNC(LAST_DAY (SYSDATE - 1))

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...