Capture First Monday From Each Month

[jay_l_a]

...or you can use next_day..

eg, give me the first Monday AFTER the last day in September (ie the first in October)

SELECT NEXT_DAY('30-SEP-07','Monday')
FROM dual;

j