- 示例数据，需要格式化为"YYYY-MM-DD HH24:MI:SS" 的格式
data2
Thu Mar 10 21:10:00 CST 2022
Tue Mar 08 21:00:20 CST 2022
Sun Jan 02 16:12:00 CST 2022
Wed Mar 09 21:05:00 CST 2022
Thu Mar 10 21:10:00 CST 2022
sql
SELECT TO_CHAR(TO_TIMESTAMP(SUBSTRING(data2 FROM 1 FOR 20), 'Dy Mon DD HH24:MI:SS YYYY'), 'YYYY-MM-DD HH24:MI:SS')
FROM my_table WHERE tid = 1081 AND data2 LIKE '%CST%';
