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

How to change Employee Number Generation from Manual to Automatic in Oracle HRMS (When attempting to apply for a job in iRecruitment)

When attempting to apply for a job in iRecruitment, the following error occurs: ERROR: You must enter an Application Number. Solution: How t...