update T_JBXX_JBXX
set CSRQ = (select substr(SFZJH, 7, 4)
from T_JBXX_JBXX||'-'||
select substr(SFZJH, 11, 2)
from T_JBXX_JBXX || '-' ||
select substr(SFZJH, 13, 2) from T_JBXX_JBXX
)数据库SQLupdateselect
set CSRQ = (select substr(SFZJH, 7, 4)
from T_JBXX_JBXX||'-'||
select substr(SFZJH, 11, 2)
from T_JBXX_JBXX || '-' ||
select substr(SFZJH, 13, 2) from T_JBXX_JBXX
)数据库SQLupdateselect
set CSRQ = substr(SFZJH, 7, 4) ||'-'||substr(SFZJH, 11, 2) ||'-'||substr(SFZJH, 13, 2)自己贴一个正确答案阿布!