SELECT ADD_MONTHS (TRUNC(SYSDATE,'Y'),ROWNUM -1) MONTH_FIRST_DAY
FROM ALL_OBJECTS
WHERE ROWNUM <= 12
FROM ALL_OBJECTS
WHERE ROWNUM <= 12
Showing posts with label How to find First Date of the Month using Oracle Sql Query. Show all posts
Showing posts with label How to find First Date of the Month using Oracle Sql Query. Show all posts
Thursday, 26 April 2018
Subscribe to:
Posts (Atom)