How to change mysql timezone to UTC from EDT time

Question

I have installed mysql in my linux server. My server timezone is UTC but mysql timezone in EDT. Now i want to change mysql timezone to UTC.

when i run date in linux command, it shows Fri Nov 6 09:25:01 UTC 2015

when i run select now() in mysql,it shows 2015-11-06 04:25:26.

So how to change EDT to UTC in mysql.

Note : i m using mysql workbench.

http://stackoverflow.com/questions/19023978/should-mysql-have-its-timezone-set-to-utc Check this for solution — Siddhartha esunuri, Nov 06 '15 at 09:31

score 1 · Answer 1 · answered Nov 06 '15 at 09:52

1

Set you MySQL timezone :-

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

For check timezone :-

SELECT @@session.time_zone;

location of MySQL configuration file :-

/etc/mysql/my.cnf

answered Nov 06 '15 at 09:52

Abhishek Sharma

if i check SELECT @@session.time_zone; it says "SYSTEM". – MMMMS Nov 06 '15 at 09:59
set your timezone use this :- – Abhishek Sharma Nov 06 '15 at 10:00
IF I DO SET GLOBAL time_zone = '+8:00'; SET GLOBAL time_zone = 'Europe/Helsinki'; SET @@global.time_zone='+00:00'; THEN THIS IS SHOW MY MYSQL TIMEZONE utc? – MMMMS Nov 06 '15 at 10:00
SET GLOBAL time_zone = '+8:00'; SET GLOBAL time_zone = 'Europe/Helsinki'; SET @@global.time_zone='+00:00'; – Abhishek Sharma Nov 06 '15 at 10:00
if you set your country timezone it will automatic solve your problem – Abhishek Sharma Nov 06 '15 at 10:02
SO WHAT IS SET GLOBAL time_zone = '+8:00'; SET GLOBAL time_zone = 'Europe/Helsinki'; ? is this make UTC timezone? – MMMMS Nov 06 '15 at 10:04
check your country timezone and set – Abhishek Sharma Nov 06 '15 at 10:15
Let us [continue this discussion in chat](http://chat.stackoverflow.com/rooms/94416/discussion-between-m-manivasagam-and-rahautos). – MMMMS Nov 06 '15 at 10:21

Rahul Tripathi · Answer 2 · 2015-11-06T09:45:56.190

0

You can try like this:

SELECT CONVERT_TZ(NOW(), @@session.time_zone, '+00:00')

CONVERT_TZ() converts a datetime value dt from the time zone given by from_tz to the time zone given by to_tz and returns the resulting value.

edited Nov 06 '15 at 09:45

answered Nov 06 '15 at 09:33

Rahul Tripathi

score 0 · Answer 3 · answered Nov 06 '15 at 17:48

0

If all you care about is the current time, you don't have to do any conversions or worry about time zones. Just use the appropriate function.

See Date and Time Functions in the MySQL documentation.

answered Nov 06 '15 at 17:48

Matt Johnson-Pint

i am using select now() in many place in my application so i should change the mysql timezone to UTC. – MMMMS Nov 06 '15 at 17:50
That's another way to do it, sure. But I would be very careful to examine all the places you are doing it. It's not so much the functions that matter, but if you've been writing local time data to your tables and now you start writing UTC data instead, then the mismatch will be a big problem. Think about how to convert existing data first. – Matt Johnson-Pint Nov 06 '15 at 17:54

3 Answers3