CODEWITHSUNDEEP
mysqlsqltimezoneutc
John Smith
John Smith

Reputation: 8851

How to change a MySQL database to UTC?

I'm on Windows 7 and I'm a bit new to this database stuff. I tried searching on Google for how to change the timezone from my system to UTC but the documents are somewhat advanced and I'm not too sure how to change this field.

Upvotes: 9

Views: 14966

Answers (1)

dugas
dugas

Reputation: 12463

In your my.ini file, under the [mysqld] section, add the following line:

default-time-zone = '+00:00'

Restart the server. You could also set it at runtime from the command line with

mysql> SET GLOBAL time_zone = '+00:00';

The documentation from MySql

Upvotes: 20

Related Questions