Using BETWEEN in oracle dates

select *
from my_table
where trunc(record_insert_date) between to_date('02-Feb-2012', 'DD-MON-YYYY') and to_date('04-Apr-2012', 'DD-MON-YYYY')