Hello,
firstly please get familiar with Oracle documentation, as it contains a lot of useful information. It is available e.g. online on
http://tahiti.oracle.com/.
In SQL Reference book, you would find this info (located
here fror 11gR1):
Quote:
Datetime Format Elements
Element
Description
WW
Week of year (1-53) where week 1 starts on the first day of the year and continues to the seventh day of the year.
IW
Week of year (1-52 or 1-53) based on the ISO standard.
|
ISO week starts always on Monday regardless any settings. If you want the week to start on different day, you have to adjust it. For Sunday, adding one day (+ INTERVAL '1' DAY or simply + 1) to the source date shall do the job.