Capture First Monday From Each Month

Hi All,

I need to capture first Monday date of each month, how it is possible?

e.g Oct, 01/2007, Nov, 05/07, Dec, 03/07 ......


Thanks,
Arshad

First Monday of each month has to be in between day(1,7)
Do a loop and ask Oracle for the name of the day, when Monday=True you got your match.

Thanks for the information.!

...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