<div>
Will the above work even when, say, &nbsp;the middle of the week is a new month?
</div>


Will the above work even when, say,  the middle of the week is a new month?

<div>
yes author, the solution which flow01 will work fine even in case the middle of week is a new month...<br />
<br />
what in actual it does it, it truncates the day to start of the week,..<br />
<br />
for example 01/Mar/2012 is thursday, <br />
<br />
select trunc(to_date('01-Mar-2012<wbr />','DD-Mon-<wbr />YYYY'),'WW<wbr />') from dual<br />
<br />
this will result in 26th Feb 2012, which is start of the week and by default the start of week in oracle is sunday..
</div>


yes author, the solution which flow01 will work fine even in case the middle of week is a new month...

what in actual it does it, it truncates the day to start of the week,..

for example 01/Mar/2012 is thursday,

select trunc(to_date('01-Mar-2012','DD-Mon-YYYY'),'WW') from dual

this will result in 26th Feb 2012, which is start of the week and by default the start of week in oracle is sunday..

<div>
<div class="content wysiwyg-content">
I'd like to create a report which will run every Monday morning showing data for the previous week; Sun - Sat.<br />
<br />
CLOSED_DTTM &gt;&nbsp;trunc(SYSDATE)- 7 is not working.<br />
<br />
What should I use?<br />
<br />
Thanks.
</div>
</div>


I'd like to create a report which will run every Monday morning showing data for the previous week; Sun - Sat.

CLOSED_DTTM > trunc(SYSDATE)- 7 is not working.

What should I use?

Thanks.

ORACLE previous week date function

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.