1 2 Previous Next 18 Replies Latest reply: Mar 8, 2013 10:43 AM by ranit B RSS

    How to get the date for the first monday of each month

    9876564
      Dear Members,

      How to get the date for the first monday of each month.

      I have written the following code

      SELECT decode (to_char(trunc(sysdate+30 ,'MM'),'DAY'),'MONDAY ',trunc(sysdate+30 ,'MM'),NEXT_DAY(trunc(sysdate+30 ,'MM'), 'MON')) FROM DUAL

      But it look bith complex.

      Abhishek

      Edited by: 9999999 on Mar 8, 2013 4:30 AM
        1 2 Previous Next