SQLITE update 字符串拼接与截取

UPDATE trade_rc SET TIMESIGN=(SUBSTRING(TIME,1,4)||SUBSTRING(TIME,6,2)||SUBSTRING(TIME,9,2))