开发者

How to change a MySQL database to UTC?

开发者 https://www.devze.com 2023-02-18 21:03 出处:网络
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 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.


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

0

精彩评论

暂无评论...
验证码 换一张
取 消