This discussion is archived
1 2 Previous Next 18 Replies Latest reply: Mar 8, 2013 8:43 AM by ranit B RSS

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

9876564 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points