<div>
Got it... im sure it may have flaws somewhere but for its purpose it is returning the expectd result.<br />
<br />
to_number(to_char(trunc(sy<wbr />sdate) + 2, 'IW'))<br />
<br />
Cheers
</div>


<div>
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
</div>


<div>
<div class="content wysiwyg-content">
Ive found many many examples of Datepart conversions which are all simple if you use only the standard version which is:<br />
<br />
DataPart(&quot;WW&quot;, DateValue)<br />
<br />
But my issue is with the FirstDayOfWeek optional parameter that DatePart uses. &nbsp;I need to convert a DatePart line that looks like:<br />
<br />
DatePart(&quot;WW&quot;, DateValue, 3)<br />
<br />
The 3 is an optional value that allows you to choose what the first day of the week is based on. &nbsp;In this case 3 stands for Tuesday.<br />
<br />
Thank you
</div>
</div>


Ive found many many examples of Datepart conversions which are all simple if you use only the standard version which is:

DataPart("WW", DateValue)

But my issue is with the FirstDayOfWeek optional parameter that DatePart uses.  I need to convert a DatePart line that looks like:

DatePart("WW", DateValue, 3)

The 3 is an optional value that allows you to choose what the first day of the week is based on.  In this case 3 stands for Tuesday.

Thank you

Got it... im sure it may have flaws somewhere but for its purpose it is returning the expectd result.

to_number(to_char(trunc(sysdate) + 2, &#39;IW&#39;))

Cheers

This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.

Converting a Datepart query to Oracle pl/sql

Ive found many many examples of Datepart conversions which are all simple if you use only the standard version which is:

DataPart(&quot;WW&quot;, DateValue)

But my issue is with the FirstDayOfWeek optional parameter that DatePart uses.  I need to convert a DatePart line that looks like:

DatePart(&quot;WW&quot;, DateValue, 3)

The 3 is an optional value that allows you to choose what the first day of the week is based on.  In this case 3 stands for Tuesday.

Thank you

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

The successor to Active Server Pages, ASP.NET websites utilize the .NET framework to produce dynamic, data and content-driven web applications and services. ASP.NET code can be written using any .NET supported language. As of 2009, ASP.NET can also apply the Model-View-Controller (MVC) pattern to web applications

ASP.NET

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.