sql语句
select * from emp_copy ec where ec.字段名 between to_date('2012/10', 'yyyy/mm') and to_date('2017/03', 'yyyy/mm')
注:把表名和对应字段名字替换成你的表明和字段名字
请采用以下脚本
select * from [表名] where date >='2012-10-1 0:00:00' and date <='2017-3-31 23:59:59'
请采纳!