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

How to install and configure Oracle Apex 24.1 with ORDS 22, Tomcat 9 and Jasper Report 7 on Oracle Linux 8.10

#########################Install Oracle  APEX 24.1################################ ----------------------------------------------------...