--## 2021.01.26  caishb ZYDZBL-20210112-004    中医治法信息新增诊断日期时间字段
alter table SD_ZS.BA_ZYZFXX add (ZDRQ00 char(8) default  to_char(sysdate,'yyyyMMdd') null);
comment on column SD_ZS.BA_ZYZFXX.ZDRQ00 is '诊断日期';

alter table SD_ZS.BA_ZYZFXX add (ZDSJ00 char(8) default to_char(sysdate,'HH24:mi:ss') null);
comment on column SD_ZS.BA_ZYZFXX.ZDSJ00 is '诊断时间';