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

最新推荐文章于 2021-10-08 20:44:37 发布

原创最新推荐文章于 2021-10-08 20:44:37 发布 · 1.8k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#oracle #mybatis

JAVA 专栏收录该内容

9 篇文章

订阅专栏

博客展示了Oracle数据库的查询和更新语句，如从MEDREC.PAT_MASTER_INDEX表查询患者信息，还涉及日期格式转换。同时提到查询出的birthday在使用MyBatis自动转换时会报错，最终取消了to_char操作。

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;