Thursday, 26 April 2018

How to find First Date of the Month using Oracle Sql Query

SELECT ADD_MONTHS (TRUNC(SYSDATE,'Y'),ROWNUM -1) MONTH_FIRST_DAY
FROM ALL_OBJECTS
WHERE ROWNUM <= 12

No comments:

Post a Comment

Delete Organization Classification and Organization Using API when BG - Business Group Setup

  Oracle HRMS – Delete Organization Classification and Organization Using API 📘 Overview In Oracle HRMS, each organization is classified ...