oracle sql query for records with timestamp that falls between two timestamps
None of the above answers worked for me.
however, First simply replace 'T' you have with a ' '(space) and use below query which worked for me
select * from tb1 where timestamps BETWEEN TO_DATE ('2015-05-06 15:39:00', 'YYYY-mm-dd HH24:MI:SS') AND TO_DATE('2015-04-06 15:39:00', 'YYYY-mm-dd HH24:MI:SS');