<div>
I assume you have a column that has date or timestamp data type?<br />
is the field indexed?<br />
<br />
you could use the TO_CHAR() function:<br />
<a href="http://www.techonthenet.com/oracle/functions/to_char.php" rel="ugc">http://www.techonthenet.com/oracle/functions/to_char.php</a><br />
<br />
however, if you could determine the start and end date of the week, it should be easier...<br />

</div>


I assume you have a column that has date or timestamp data type?
is the field indexed?

you could use the TO_CHAR() function:
http://www.techonthenet.com/oracle/functions/to_char.php [http://www.techonthenet.com/oracle/functions/to_char.php]

however, if you could determine the start and end date of the week, it should be easier...


<div>
<div class="content wysiwyg-content">
folks<br />
<br />
how do i run a serach in oracle against a year and a week?<br />
<br />
i.e &nbsp;select * from table where year ='2008' and week is '21'<br />

</div>
</div>


folks

how do i run a serach in oracle against a year and a week?

i.e  select * from table where year ='2008' and week is '21'


oracle, 10, database, query by year and week in oracle

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.