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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Calculating the Week of the Year when "Stat Week" runs Sunday through Saturday.

Re: Calculating the Week of the Year when "Stat Week" runs Sunday through Saturday.

From: Tim Frawley <tim_frawley_at_fishgame.state.ak.us>
Date: 2 Mar 2005 13:23:25 -0800
Message-ID: <1109798605.532026.123060@f14g2000cwb.googlegroups.com>


Ken,

Thanks for the reply, sorry to take so long to get back to you. I tried the function and encountered a problem. It appears that despite using in_date-1 the NEXT_DAY(in_date-1,'SAT') is still returning the Saturday a week later. If I put in a Date of 2-JAN-2000 the NEXT_DAY(in_date-1,'SAT') returns: 08-JAN-00.

Tim Received on Wed Mar 02 2005 - 15:23:25 CST

Original text of this message

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