oracle to_char 转换日期遇到0000-00-00 问题

SELECT
            p.PATIENT_ID AS "patientId",
            UTL_RAW.CAST_TO_RAW(p.NAME) AS "patientNameByte",
            p.ID_NO AS "idCardNo",
--             NULL AS "outPatientNo",
            p.INP_NO AS "inPatientNo",
            p.DATE_OF_BIRTH AS "birthday2",
            TO_CHAR(p.DATE_OF_BIRTH,'yyyy-mm-dd hh24:mi:ss') AS "birthday",
            UTL_RAW.CAST_TO_RAW(p.SEX) AS "genderByte",
            UTL_RAW.CAST_TO_RAW(p.NATION) AS "nationByte",
            p.CREATE_DATE AS "originalCreateDate"
        FROM
            MEDREC.PAT_MASTER_INDEX p
        WHERE
                 p.PATIENT_ID ='00340645';
 select TO_CHAR(SYSDATE,'yyyy-mm-dd hh:mi:ss') test from dual;
 select to_date('0000-00-00','yyyy-mm-dd')+1 test from dual;
 update   MEDREC.PAT_MASTER_INDEX p SET p.DATE_OF_BIRTH = to_date('0001-01-01 00:00:00','yyyy-mm-dd hh24:mi:ss')-1 
   WHERE
                 p.PATIENT_ID ='00340645';
 select * from v$version;

 

查询出的bithday 再使用mybatis 自动转换的时候会报错，所以最后取消了to_char