Hi all,

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

my script for serverPerformanceWeekly.

select hostname, to_char(to_date(&date_start, 'YYYYMMDD') , 'YYYY'),
to_char(to_date(&date_start, 'YYYYMMDD') , 'WW'), genesis_port,
instance_name,
api_name, sum(total_time), max(max_time), min(min_time),
(sum(total_time)/sum(count)), sum(count)
from gen_api_performance_daily
where to_char(statistics_date,'YYYYMMDD') between &date_start and
&date_end
group by hostname, to_char(to_date(&date_start, 'YYYYMMDD') ,
'YYYY'), to_char(to_date(&date_start, 'YYYYMMDD') , 'WW'),
genesis_port, instance_name, api_name;

25c23db0006c (AT) p39g2000hsb (DOT) googlegroups.com>, says...

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

25c23db0006c (AT) p39g2000hsb (DOT) googlegroups.com>, says...

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

25c23db0006c (AT) p39g2000hsb (DOT) googlegroups.com>, says...

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

25c23db0006c (AT) p39g2000hsb (DOT) googlegroups.com>, says...

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

On Oct 29, 10:01*am, Geoff Muldoon <geoff.muld... (AT) trap (DOT) gmail.com>
wrote:
I'm trying to research how to return the correct WW value (week starts
on a Sunday). have you encountered this before in SQL?

On Oct 29, 10:01*am, Geoff Muldoon <geoff.muld... (AT) trap (DOT) gmail.com>
wrote:
I'm trying to research how to return the correct WW value (week starts
on a Sunday). have you encountered this before in SQL?

On Oct 29, 10:01*am, Geoff Muldoon <geoff.muld... (AT) trap (DOT) gmail.com>
wrote:
I'm trying to research how to return the correct WW value (week starts
on a Sunday). have you encountered this before in SQL?

On Oct 29, 10:01*am, Geoff Muldoon <geoff.muld... (AT) trap (DOT) gmail.com>
wrote:
I'm trying to research how to return the correct WW value (week starts
on a Sunday). have you encountered this before in SQL?

<6b3da48e-93a1-488b-b585-076ef793736c (AT) t65g2000hsf (DOT) googlegroups.com>,
says...
Oops, led you up the wrong path there.

I think you're looking for 'IW' (week of year based on ISO standard)
rather than 'WW" (week of year calculated on weeks starting on the day of
the week defined by whatever January 1st was).

Geoff M