Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Find First of Month
Again, Thank You everyone.
I am using the following
TO_CHAR(LAST_DAY(ADD_MONTHS(E.HIRE_DT, 6))+1, 'IW') This gives me the week number 6 months after the employee hire date! Exactly what I was looking for.
THANK YOU AGAIN!!! FireGeek Received on Thu Jul 13 2006 - 16:49:02 CDT