如果你e_createtime是DATE型: select * from tbl_expertnews t where t.e_createtime >= to_date('2007-5-1','yyyy-MM-dd' and t.e_createtime <= to_date('2007-5-17','-MM-dd')
改为 select * from tbl_expertnews t where t.e_createtime >= '2007-05-01' and t.e_createtime <= '2007-05-17'试下
select * from tbl_expertnews t where t.e_createtime >= to_date('2007-5-1', 'yyyy-mm-dd') and t.e_createtime <= to_date('2007-5-17', 'yyyy-mm-dd')
select * from tbl_expertnews t where t.e_createtime >= to_date('2007-5-1','yyyy-MM-dd' and t.e_createtime <= to_date('2007-5-17','-MM-dd')
select * from tbl_expertnews t where t.e_createtime >= '2007-05-01' and t.e_createtime <= '2007-05-17'试下