原始数据 #yyyymmddhhiiss(年月日时分秒) 20181218185100
转化成 Y-m-d H:i:s
(2018-12-18 18:51:00)
update p_data set treatDate =
CONCAT(
SUBSTR(treatDate, 1, 4),
'-',
SUBSTR(treatDate, 5, 2),
'-',
SUBSTR(treatDate, 7, 2),
' ',
SUBSTR(treatDate, 9, 2),
':',
SUBSTR(treatDate, 11, 2),
':',
SUBSTR(treatDate, 13, 2)
)