MySQL Forums
Forum List  »  Install & Repo

system_time_zone suddenly set to RIC, times off by 5 hours
Posted by: Brian Barnes
Date: June 04, 2014 06:21PM

Suddenly this morning, NOW() and timestamps are all in UTC, not localtime so they are 5 hours off.
Windows 7/64 clock is right and timezone is correctly set to US central time. $ENV{TZ}='CDT' and
'GMT-5:00', 'UTC-5:00', "America/Chicago" and others were tried and not understood by Mysql.

show variables where variable_name like '%zone%' →
system_time_zone ric
time_zone -05:00

The “time_zone” was fixed by adding “default-time-zone = -5:00” to my.inid->[mysqld] and restarting the server.

There seems to be no documented way on dev.mysql.com to permanently fix the “system_time_zone=ric” problem. The suggestion to “consult [windows] documentation...” is not helpful.

A permanent, one-time, config fix rather than some ad hoc set statement for every session is preferable.

There seems to be a bug in the 5.6 doc, 10.6 MySQL Server Time Zone Support:
global server time zone value can be specified . . . in an option file:
default-time-zone='timezone'
This directive alters only the “TIME_ZONE” variable, not the “system_time_zone” variable which would appear to be the GLOBAL of the 2.

What is the my.ini verbiage needed to fix the “system_time_zone = ric” problem and where can the documentation be found? A link to bookmark would be handy.

set time_zone='GMT-5:00' ==>> Lookup Error - MySQL Database Error: Unknown or incorrect time zone: 'GMT-5:00'

No “STANDARD” timezones are understood and the time_zone table is empty. mysql-5.6.16-winx64

Options: ReplyQuote


Subject
Written By
Posted
system_time_zone suddenly set to RIC, times off by 5 hours
June 04, 2014 06:21PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.