I want query datetime many time. but i try query it's not work.
Example
Table cus_bill
Number Period
A-20160101 01/2015
A-20160410 04/2015
A-20160912 09/2015
A-20161020 10/2015
A-20161102 11/2015
A-20161219 12/2015
SQL
SELECT v.*
FROM cus_bill v
WHERE TO_DATE('01/'||V.PERIOD,'DD/MM/YYYY') >= TO_DATE('01/'|| '10/2015','DD/MM/YYYY')
and TO_DATE('01/'||V.PERIOD,'DD/MM/YYYY') <= TO_DATE('01/'|| '12/2015','DD/MM/YYYY')
and V.PERIOD IN ('01/2015','09/2015')
But it's not work (0 Rows).
Desired output:
Number Period
A-20160101 01/2015
A-20160912 09/2015
A-20161020 10/2015
A-20161102 11/2015
A-20161219 12/2015