ORA-01830: date format picture ends before converting entire input string

这个错误是日期格式化的问题；

例子：

SELECTCOUNT (*) AS col_0_0_
FROMSAF_T_PREPLAN_DRILL saftprepla0_
WHEREsaftprepla0_.DEL_FLAG = '0'
AND saftprepla0_.MAIN_DEPT ='0100'
AND saftprepla0_.PLAN_TIME >= TO_DATE ('2018-01-01', 'yyyy-MM')
AND saftprepla0_.PLAN_TIME <= TO_DATE ('2018-11-1', 'yyyy-MM')

format的数据类型和所要查询的数据类型并不一致。