data+String = date

  
   insert into TJ_ZBYSGJ_BASE(select seq_uid.nextval,
       c.fcj,
       b.jsj,
       a.zbid,
       a.zbtm,
       a.yjjdm,
       a.jdjdm,
       a.yjzl,
       to_date((to_char(b.qsrq, 'yyyy-mm-dd') || ' ' ||
               substr(b.qssj, 0, 2) || ':' || substr(b.qssj, 3, 4)),
               'yyyy-mm-dd hh24:mi:ss'),
       to_date((to_char(c.jsrq, 'yyyy-mm-dd') || ' ' ||
               substr(c.jssj, 0, 2) || ':' || substr(c.jssj, 3, 4)),
               'yyyy-mm-dd hh24:mi:ss')
  from qzbxxb a, qckldb b, qjkldb c
 where a.ckldid = b.ldid
   and c.ldid = a.jkldid)
---找出数据
select * from TJ_ZBYSGJ_BASE

---存储过程


select * from TJ_ZBYSSX
---报表
select to_date((to_char(d.qsrq, 'yyyy-mm-dd') || ' ' ||
               substr(d.qssj, 0, 2) || ':' || substr(d.qssj, 3, 4)),
               'yyyy-mm-dd hh24:mi:ss')
  from qckldb d