Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Calculating the Week of the Year when "Stat Week" runs Sunday through Saturday.
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
![]() |
![]() |