查看當(dāng)前會(huì)話時(shí)區(qū)

SELECT @@session.time_zone;

設(shè)置當(dāng)前會(huì)話時(shí)區(qū)

SET time_zone = 'Europe/Helsinki';
SET time_zone = "+00:00";

數(shù)據(jù)庫(kù)全局時(shí)區(qū)設(shè)置

SELECT @@global.time_zone;

設(shè)置全局時(shí)區(qū)

SET GLOBAL time_zone = '+8:00';
SET GLOBAL time_zone = 'Europe/Helsinki';