Re: Find First of Month

Thanks everyone for the help.

SELECT LAST_DAY(ADD_MONTHS(SYSDATE, 2))+1 This seems to be the best solution.

One more question:
Is there a way to determine what week a particular date is? Considering a calendar year is 52 weeks, I am looking at finding what week say 07/10/2006 is (which would be week 28).

Any ideas?

THANKS AGAIN!!! FireGeek Received on Thu Jul 13 2006 - 15:25:52 CDT