Tag: MySQL/タイムゾーン
mysql> SELECT @@global.time_zone, @@session.time_zone; +--------------------+---------------------+ | @@global.time_zone | @@session.time_zone | +--------------------+---------------------+ | SYSTEM | SYSTEM | +--------------------+---------------------+
mysql > show variables like '%time_zone%'; +------------------+--------+ | Variable_name | Value | +------------------+--------+ | system_time_zone | JST | | time_zone | SYSTEM | +------------------+--------+
mysql> SET GLOBAL time_zone = timezone; mysql> SET GLOBAL time_zone = SYSTEM mysql> SET GLOBAL time_zone = '+0:00'
mysql> SET time_zone = timezone;