查看Mysql 當(dāng)前的時(shí)區(qū)
SELECT TIMEDIFF(NOW(), UTC_TIMESTAMP);
待導(dǎo)入的數(shù)據(jù)時(shí)間格式
2020-04-01T08:24:37-04:00
修正時(shí)區(qū)并創(chuàng)建新表
SELECT
id,
title,
sublocation,
url,
description,
created_at AS time_full,
substring( created_at,- 6 ) AS time_zone,
CONVERT_TZ(
substring( created_at, 1, 19 ),
substring( created_at,- 6 ),
'-05:00'
) AS created_at ,
CONVERT_TZ(
substring( created_at, 1, 19 ),
substring( created_at,- 6 ),
'-05:00'
) AS updated_at
FROM
`external_projects`
LIMIT 50
