Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Find First of Month

Re: Find First of Month

From: Jeroen van den Broek <Jeroen_at_baasbovenbaas.demon.nl>
Date: 14 Jul 2006 04:57:57 -0700
Message-ID: <1152878277.180761.36490@b28g2000cwb.googlegroups.com>

FireGeek wrote:
> 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.

No it won't.
It will give you the week for the 1th day of the next month, following that 6 months period.
If the employee was hired at April 15th, it will *not* give you the week for October 15th but for November 1st, i.e. 6.5 months after the hire date.
If the employee was hired at April 1st, it will *not* give you the week for October 1st but for November 1st, i.e. 7 months after the hire date.

>
> THANK YOU AGAIN!!!
>

First: 90 days --> 3 - 4 months
Now: 6 months --> 6 - 7 months
Try to be more precise when stating your problem.. ;-)

-- 
Jeroen
Received on Fri Jul 14 2006 - 06:57:57 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US