How to query Where Datetime many time?

<p>I want query datetime many time. but i try query it's not work.</p><p><strong>Example</strong></p><p>Table cus_bill</p><pre><br /><code>Number Period<br />A-20160101 01/2015<br />A-20160410 04/2015<br />A-20160912 09/2015<br />A-20161020 10/2015<br />A-20161102 11/2015<br />A-20161219 12/2015<br /></code><br /></pre><p><strong>SQL</strong></p><pre><br /><code>SELECT v.*<br />FROM cus_bill v<br />WHERE TO_DATE('01/'||V.PERIOD,'DD/MM/YYYY') >= TO_DATE('01/'|| '10/2015','DD/MM/YYYY') <br />and TO_DATE('01/'||V.PERIOD,'DD/MM/YYYY') <= TO_DATE('01/'|| '12/2015','DD/MM/YYYY')<br />and V.PERIOD IN ('01/2015','09/2015') <br /></code><br /></pre><p>But it's not work (0 Rows).</p><p><strong>Desired output:</strong></p><pre><br /><code>Number Period<br />A-20160101 01/2015<br />A-20160912 09/2015<br />A-20161020 10/2015<br />A-20161102 11/2015<br />A-20161219 12/2015<br /></code><br /></pre><br /><h2>Click here view more answers <a href="http://ift.tt/1UjFqr5">http://ift.tt/1UjFqr5</a></h2>