Re: return the correct WW value

On Oct 29, 10:01 am, Geoff Muldoon <geoff.muld..._at_trap.gmail.com> wrote:
> 25c23db00..._at_p39g2000hsb.googlegroups.com>,  says...
>
>
>
> > I have a problem for retrieving a correct ww. I hit a snag while
> > testing the serverPerformanceWeekly script.  It seems the
> > TO_CHAR(<date>,'WW') function is not returning the correct value.  See
> > sample below for 26-Oct-2008 (last Sunday), 43 was returned instead of
> > 44. How shud i do?
>
> > SQL> select to_char(to_date('20081026','YYYYMMDD'),'WW') from
> > serverPerformanceWeekly;
>
> > TO
> > --
> > 43
>
> >  SQL> select to_char(sysdate, 'WW') from dual;
>
> > 44
>
> On what "sysdate" did you run the above to get that result?  On the Monday
> after you discovered the "error" or actually on the Sunday?  Did you run
> the above form a client connection?  What's your (client and server)
> NLS_TERRITORY setting?  Does that setting default the first day of the
> week as a Sunday or as a Monday?
>
> Geoff M

I'm trying to research how to return the correct WW value (week starts on a Sunday). have you encountered this before in SQL? Received on Tue Oct 28 2008 - 21:14:40 CDT