备用 将DD-MM-YYYY HH:MM:SS转化为SQLite 支持的YY-MM-DD HH:MM:SS

UPDATE t2 SET Comeback_Date = (SELECT CASE WHEN (SUBSTR(Comeback_Date,-8,1)=' ') THEN SUBSTR(Comeback_Date,-12,4) ELSE SUBSTR(Comeback_Date,-13,4) END)|| '-'|| (SELECT CASE WHEN (CAST(SUBSTR(Comeback_Date,1,2) AS INTEGER) >=10 and SUBSTR(Comeback_Date,5,1)!='-') THEN SUBSTR(Comeback_Date,4,2) WHEN (CAST(SUBSTR(Comeback_Date,1,2) AS INTEGER) >=10 and SUBSTR(Comeback_Date,5,1)='-') THEN SUBSTR(Comeback_Date,4,1)  WHEN (CAST(SUBSTR(Comeback_Date,1,2) AS INTEGER) <10 and SUBSTR(Comeback_Date,4,1)='-') THEN SUBSTR(Comeback_Date,3,1) ELSE SUBSTR(Comeback_Date,3,2) END)|| '-'|| (SELECT CASE WHEN (CAST(SUBSTR(Comeback_Date,1,2) AS INTEGER) >=10) THEN SUBSTR(Comeback_Date,1,2) ELSE SUBSTR(Comeback_Date,1,1) END) ||' '|| (SELECT CASE WHEN SUBSTR(Comeback_Date,-8,1)=' 'THEN SUBSTR(Comeback_Date,-7) ELSE SUBSTR(Comeback_Date,-8) END) where Comeback_Date is not null;


update t1 set comeback_date=(substr(comeback_date, 1,4)||'-'||
(select case when(cast(substr(comeback_date,6,2) as integer)>=10) then substr(comeback_date,6,2) else '0'||substr(comeback_date,6,1) end) ||'-'||
(select case when(cast(substr(comeback_date,8,2) as integer)>=10) then substr(comeback_date,8,2) when(cast(substr(comeback_date,9,2) as integer)>=10) then substr(comeback_date,9,2) when(cast(substr(comeback_date,8,2) as integer)>0) then '0'||substr(comeback_date,8,1) else '0'||substr(comeback_date,9,1) end) ||' '||(select case when (substr(comeback_date,-8,1)=' ') then '0'||substr(comeback_date,-7) else substr(comeback_date,-8) end)
)
where comeback_date is not null