return the correct WW value

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;