<div>
you could put the trunc on sysdate as well<br />
<br />
select * from tbl where date&gt;=add_months(trunc(sys<wbr />date,'mm')<wbr />,-6)<br />
<br />
<br />
both of these assume you want everything from Nov 1 of previous year up through current day and time, and that there is no future-dated data<br />
<br />
if you might have future-dated data, then add an additional clause<br />
<br />
AND date &lt;= sysdate
</div>


you could put the trunc on sysdate as well

select * from tbl where date>=add_months(trunc(sysdate,'mm'),-6)


both of these assume you want everything from Nov 1 of previous year up through current day and time, and that there is no future-dated data

if you might have future-dated data, then add an additional clause

AND date <= sysdate

<div>
You can also use this:<br />
<br />
SELECT * FROM &lt;&lt;TABLE&gt;&gt; WHERE trunc(&lt;&lt;YOUR DATE COLUMN&gt;&gt;,'MM') &gt;= ADD_MONTHS(SYSDATE,-6)<br />
AND &lt;&lt;YOUR DATE COLUMN&gt;&gt; &lt;= sysdate;<br />
<br />

</div>


You can also use this:

SELECT * FROM <<TABLE>> WHERE trunc(<<YOUR DATE COLUMN>>,'MM') >= ADD_MONTHS(SYSDATE,-6)
AND <<YOUR DATE COLUMN>> <= sysdate;



<div>
putting TRUNC on the column prevents use of most &nbsp;indexes and isn't recommended
</div>


putting TRUNC on the column prevents use of most  indexes and isn't recommended

<div>
select * from tbl where date&gt;='01-'||to_char(add_m<wbr />onths(sysd<wbr />ate,-6),'M<wbr />ON-YYYY')<br />
<br />
OR <br />
<br />
select * from tbl where date&gt;=LAST_DAY(add_months(<wbr />sysdate,-7<wbr />))+1
</div>


select * from tbl where date>='01-'||to_char(add_months(sysdate,-6),'MON-YYYY')

OR

select * from tbl where date>=LAST_DAY(add_months(sysdate,-7))+1

<div>
<div class="content wysiwyg-content">
Greeting,<br />
<br />
I try to use add_months function to get me all the data for the previous 6 month up to now.<br />
I have select * from tbl where date&gt;=add_months(sysdate,-<wbr />6)<br />
The above sql will give me the data from Nov 13th to May 13th(Now).<br />
How to get data from Nov 1st to May 13th?<br />
<br />
Thanks.
</div>
</div>


Greeting,

I try to use add_months function to get me all the data for the previous 6 month up to now.
I have select * from tbl where date>=add_months(sysdate,-6)
The above sql will give me the data from Nov 13th to May 13th(Now).
How to get data from Nov 1st to May 13th?

Thanks.

add_months function 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.