Capture First Monday From Each Month
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 ......
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.
Pablo (Paul) Berzukov
Author of Understanding Database Administration
available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
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)
Click Here to Expand Forum to Full Width