Re: return the correct WW value

<jjjackjill89_at_gmail.com> a écrit dans le message de news: 6b3da48e-93a1-488b-b585-076ef793736c_at_t65g2000hsf.googlegroups.com... 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?

You should have a closer look at datetime format elements definition: http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/sql_elements004.htm#i34948

Regards
Michel Received on Tue Oct 28 2008 - 23:40:55 CDT