通过这个sql 可以看到对应的时区编码和时区的偏移量

SELECT
    tz.Name AS TimeZone,
    tt.Abbreviation AS Abbreviation,
    tt.Is_DST AS IsDST,
    tt.Offset / 3600 AS OffsetInHours
FROM
    mysql.time_zone_name AS tz
JOIN
    mysql.time_zone_transition_type AS tt
ON
    tz.Time_zone_id = tt.Time_zone_id

order by OffsetInHours asc

;