ORA-01849错误的出现主要需注意HH与HH24的区别，如下：

错误用法

SELECT TO_DATE('2011-12-20 20:00:00','YYYY-MM-DD HH:MI:SS') TIME FROM DUAL;

正确用法

SELECT TO_DATE('2011-12-20 11:00:00','YYYY-MM-DD HH:MI:SS') TIME FROM DUAL;

TIME

------------------

2011-12-20 11:00:00

SELECT TO_DATE('2011-12-20 20:00:00','YYYY-MM-DD HH24:MI:SS') TIME FROM DUAL;

TIME

------------------

2011-12-20 20:00:00

[@more@]

ITPub博客

ORA-01849