trim(CKDH00)||'T'||A.zyid00||decode(c.ZXSJ00,'早餐','000','午餐','001','晚餐','002','睡前','003','')
      ||substr(to_char(DYRQ00),-2) TXMNUM,
  decode(c.ZXSJ00,'08:00:00','早餐','12:00:00','午餐','16:00:00','晚餐','20:00:00','睡前',substr(c.ZXSJ00,1,2)||'点') ZXSJ00,
  substr(c.ZXRQ00,1,4)||'/'||substr(c.ZXRQ00,5,2)||'/'||substr(c.ZXRQ00,7,2) DYRQ00