<div>
or use &gt;= &nbsp;&lt;=<br />
<br />
<br />
where full_date &gt;=trunc(sysdate)-31 and <br />
full_date &lt;= trunc(sysdate)-1 + (86399/86400)<br />
<br />
or <br />
<br />
where full_date &gt;=trunc(sysdate)-31 and <br />
full_date &lt;= trunc(sysdate) &nbsp;- (1/86400)<br />
<br />
or<br />
<br />
<br />
<br />
where full_date &gt;=trunc(sysdate)-31 and <br />
full_date &lt;&nbsp;trunc(sysdate) &nbsp; &nbsp; ----- &nbsp;note &lt;&nbsp; not &lt;=<br />
<br />
<br />

</div>


or use >=  <=


where full_date >=trunc(sysdate)-31 and
full_date <= trunc(sysdate)-1 + (86399/86400)

or

where full_date >=trunc(sysdate)-31 and
full_date <= trunc(sysdate)  - (1/86400)

or



where full_date >=trunc(sysdate)-31 and
full_date < trunc(sysdate)     -----  note <  not <=




<div>
sdstuber = great person<br />
<br />
Thanks!
</div>


<div>
and finally, one more option...<br />
<br />
<br />
where full_date between trunc(sysdate)-31 and trunc(sysdate)- (1/86400)<br />

</div>


and finally, one more option...


where full_date between trunc(sysdate)-31 and trunc(sysdate)- (1/86400)


<div>
<div class="content wysiwyg-content">
Looking for a &quot;between&quot; statement that will go back 30 days from yesterday's date and end at yesterday's date.<br />
<br />
Example if the statement ran today: <br />
...where full_date between ('1/21/2011' and '2/20/11')<br />
<br />
<br />
<br />

</div>
</div>


Looking for a "between" statement that will go back 30 days from yesterday's date and end at yesterday's date.

Example if the statement ran today: 
...where full_date between ('1/21/2011' and '2/20/11')





Oracle - Date SQL calcs

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.