MySQL Forums
Forum List  »  General

Problem with timezone
Posted by: David Arshakyan
Date: November 17, 2016 05:29AM

Hello
I have installed MySQL,version 5.6.16.My OS is FreeBSD,version is 9.3.MySQL installed on jail.When I check date I see Thu Nov 17 15:22:14 AMT 2016,I see this output also on the system.In MySQL,when I checked SELECT @@global.time_zone, @@session.time_zone; I see that global and session time zones set to SYSTEM.But when I check SELECT NOW(); I see 2016-11-17 11:23:44.I know that I can set in MySQL manually`

SET GLOBAL time_zone = '+4:00';
SET GLOBAL time_zone = 'Asia/Yerevan';
SET @@global.time_zone = '+04:00';

But I want to synchronize with system time.I know also that I can put in my.cnf`
default_time_zone=Asia/Yerevan or default-time-zone=+04:00.But this is production server and I can't restart the server.Please hel sto solve this problem.Thanks in advance.

Options: ReplyQuote


Subject
Written By
Posted
Problem with timezone
November 17, 2016 05:29AM
November 17, 2016 10:49AM
November 21, 2016 12:45AM
November 21, 2016 01:59PM
November 22, 2016 02:57AM
November 22, 2016 02:35PM
November 23, 2016 12:54AM


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.