select * from tb_product where
createdate > to_date('2011-6-15','yyyy-MM-dd') - 1
and
createdate<=to_date('2011-6-16','yyyy-MM-dd') + 1
createdate > to_date('2011-6-15','yyyy-MM-dd') - 1
and
createdate<=to_date('2011-6-16','yyyy-MM-dd') + 1