Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Confusing nested date question
One more thing...I don't think my original post title made much sense.
Anyway, I've been staring at this stuff way too long and would love any
direction or comments here.
Thanks in advance!!
"Cynic" <ksd9_at_yahoo.com> wrote in message
news:ujo49oefnrk1f5_at_corp.supernews.com...
> I have a script that updates dates on a db. However, now I am supposed to
> take into account the day of the week. So, for example, if the date is
July
> 7, 1999 (Wednesday) I need to update to July 7, 2001. HOWEVER: if July 7,
> 2001 is NOT a thursday, but a SATURDAY, I need to make it a non-weekend
work
> day. So here is what I need to do:
>
> July 7, 1999 ---->>> July 9, 2001 (this is the first work day
following
> July 7, 2001)
> So, I guess I am adding 2 years here PLUS whatever it will take to get the
> day to the work week.
> Any suggestions?
>
> Here is what I have so far (doesn't take into consideration the whole
> weekend thing):
>
> UPDATE GL_ACCT_SCHED SET EFF_DT = ADD_MONTHS(EFF_DT,
> (TRUNC((MONTHS_BETWEEN( TO_DATE('31-DEC-2000', 'DD-MON-YYYY'),
> EFF_DT))/12,0)*12)+12) where MONTHS_BETWEEN(TO_DATE('01-JAN-2001',
> 'DD-MON-YYYY'), EFF_DT) > 0;
>
>
Received on Mon Jul 22 2002 - 09:15:32 CDT