to_date 转换的时候出错
to_date ('19000101080000','YYYYMMDDHH24MISS')

转换的时候会出错：Invaild function argument: unable to parse date

请问这是怎么回事啊？
oracle里的格式不分大小写的，小时hh24（24小时制）或者hh、hh12（12小时制）分钟mi
[解决办法]
to_date('1990-01-01 08:00:00','yyyy-mm-dd hh24:mi:ss')
[解决办法]

SELECT to_date ('19000101080000','YYYYMMDDHH24MISS') FROM dual

SQL> select to_date ('19000101080000','YYYYMMDDHH24MISS') from dual;
 
TO_DATE('19000101080000','YYYY
------------------------------
1900-1-1 8:00:00