<div>
The ISO standard IW is based on starts the week on Monday, so what are you trying to do here?<br />
<br />
Given the data you provided, what are the expected results?<br />
<br />
It would also be nice to get the data in txt format instead of an image so we can set up a test case to provide tested SQL.
</div>


<div>
Here in attachment&nbsp;<a href="https://filedb.experts-exchange.com/incoming/2020/04_w17/1450770/Table-extract.xlsx" rel="ugc">Table extract.xlsx</a><br><br>you see that currently 12-APR-20 = week 15 cause the week start on a Monday. But i want the week to start on a Sunday till Saturday.<br>In the attached file on sheet "Result of the query" you will see the result that the query should give me.<a href="https://filedb.experts-exchange.com/incoming/2020/04_w17/1450771/table-result2.jpg" rel="ugc"><br><img src="https://filedb.experts-exchange.com/incoming/2020/04_w17/1450771/table-result2.jpg" class="fr-fic fr-dib"></a>
</div>


Table-extract.xlsx

table-result2.jpg

Wilder1626

<div>
You may try changing the session parameter<br><pre><code class="code-1 nolinks" id="code-20-43070941-1"><span>nls_territory</span>
</code></pre>for this, as shown here:<br><a href="https://stackoverflow.com/questions/48256816/oracle-change-start-day-of-week-tuesday" rel="ugc">https://stackoverflow.com/questions/48256816/oracle-change-start-day-of-week-tuesday</a><br>or<br><a href="https://stackoverflow.com/questions/51947541/how-to-change-the-week-start-day-as-sunday-for-database-in-oracle-for-reporting" rel="ugc">https://stackoverflow.com/questions/51947541/how-to-change-the-week-start-day-as-sunday-for-database-in-oracle-for-reporting</a><br><br>This will also influence the start of the week.<br><br>See section "What is a week?" here:<br><a href="https://searchoracle.techtarget.com/answer/Fiscal-year-ISO-week-part-2" rel="ugc">https://searchoracle.techtarget.com/answer/Fiscal-year-ISO-week-part-2</a>
</div>


<div>
<blockquote>I don't think any of the NLS parameters can affect it </blockquote>Sorry, slightwv, that's not true; see my comment above ;-)
</div>


<div>
Alex, Am i understanding it correctly that if i select the Territory AMERICA it should take Sunday as the day 1?<br>Cause currently, 12-APR-20 is still considered as week 15 and not 16.<a href="https://filedb.experts-exchange.com/incoming/2020/04_w17/1450774/1587505569765.png" rel="ugc"><br><img src="https://filedb.experts-exchange.com/incoming/2020/04_w17/1450774/1587505569765.png" class="fr-fic fr-dib"></a><br>
</div>


1587505569765.png

<div>
Do not fiddle with the database or global settings. You just need to set the parameter within your session, like: alter session set...
</div>


<div>
&gt;&gt;Sorry, slightwv, that's not true; see my comment above ;-) <br />
<br />
I went form the docs.<br />
<br />
Please post a working fiddle or livesql that shows IW returning week 16 for '12-apr-20'.<br />
<br />
Did you read the links you posted?<br />
<br />
<a href="https://stackoverflow.com/questions/51947541/how-to-change-the-week-start-day-as-sunday-for-database-in-oracle-for-reporting" rel="ugc">https://stackoverflow.com/questions/51947541/how-to-change-the-week-start-day-as-sunday-for-database-in-oracle-for-reporting</a><br />
<br />

<blockquote>
<br />
I don't think ISO weeks are affected by NLS settings. – Gordon Linoff Aug 21 '18 at 11:20<br />
<br />
<br />
From Wikipedia's &quot;ISO week date&quot; page: &quot;Weeks start with Monday.&quot; Why do you want a result called iso_week_start_date to show something that isn't actually the ISO-8601-defined start of the week? – Alex Poole Aug 21 '18 at 12:36<br />

</blockquote>
<br />
The other two links show how to roll your own which I suggested.<br />
<br />
&gt;&gt;Do not fiddle with the database or global settings.<br />
<br />
That image looks like SQL Developer settings which should be &quot;session&quot;.
</div>


<div>
slightwv's right, I have to apologize :-( I was kinda misled, sorry; been too quick this time ;-)<br>You have to do it "on your own", as slightwv already suggested...
</div>


<div>
<div class="content wysiwyg-content">
Hi, I have below query where i pull data based on the Iso week number.<br />
<br />
My problem is that a week starts on Monday till Sunday when i would like to pull from Sunday till Saturday.<br />
<br />
How can i update my below query to do so?<br />
<br />
Thanks for your help<br />
<br />

<pre><code class="code-1 nolinks" id="code-10-29179612-1"><span>SELECT User, crtd_dtt</span>
<span></span>
<span>             FROM User_Table</span>
<span></span>
<span>             WHERE (to_number(to_char( updt_dtt, 'iW')) = '16' and to_char(crtd_dtt, 'YYYY') = to_char(sysdate, 'YYYY')</span>
<span></span>
<span>             order by User ;</span>
</code></pre>
<br />
Below 2 first columns are the values and formats i can have in the table<br />
<a href="https://filedb.experts-exchange.com/incoming/2020/04_w17/1450760/table-result.jpg" target="_blank" title="table result (46 KB)"><img alt="table result" class="file-block lazyload" style="max-width: 451px;" data-src="https://filedb.experts-exchange.com/incoming/2020/04_w17/1450760/table-result.jpg" /></a>
</div>
</div>


table-result.jpg

Hi, I have below query where i pull data based on the Iso week number.

My problem is that a week starts on Monday till Sunday when i would like to pull from Sunday till Saturday.

How can i update my below query to do so?

Thanks for your help

(CODE)

Below 2 first columns are the values and formats i can have in the table


Oracle - Query IW week number from Sunday till Saturday

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.

Oracle Database

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.