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