In between not working in Oracle -

In between not working in Oracle -

hello trying fetch date using in between function in oracle it's not working have below mentioned info in oracle table

i using below mentioned query filter dates , it's give me error both menioned in image

plz help me out this

it seems trying convert date value date to_date(...) function. type of column receivedtime looks date, seek not utilize to_date function column, following:

select * use_news clientid=159 , receivedtime between to_date('04/05/2012', 'mm/dd/yyyy') , to_date('11/14/2014', 'mm/dd/yyyy') ;

oracle