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

 https://www.linkedin.com/pulse/building-real-time-database-monitoring-dashboard-oracle-khaleeq-tpwxf/