MySQL时区更改? [英] MySQL timezone change?

问题描述

我如何将当前在 UTC 中的时区更改为 GMT +1，正确的行是什么，我是否只需在 phpMyAdmin SQL 执行中输入它?

How do I change my timezone which is currently in UTC to GMT +1, what is the correct line and do i just enter it in phpMyAdmin SQL execution?

我的主人刚刚给了我这个链接 http://dev.mysql.com/doc/refman/5.1/en/time-zone-support.html 并走了，所以我有点迷茫，谢谢

My host just gave me this link http://dev.mysql.com/doc/refman/5.1/en/time-zone-support.html and went off so I'm kinda lost thanks

推荐答案

发出命令:

SET time_zone = 'America/New_York';

(或 GMT+1 的任何时区.:http://www.php.net/manual/en/timezones.php)

(Or whatever time zone GMT+1 is.: http://www.php.net/manual/en/timezones.php)

这是为单个客户端设置 MySQL 时区的命令，假设您的客户端分布在多个时区.

This is the command to set the MySQL timezone for an individual client, assuming that your clients are spread accross multiple time zones.

这个命令应该在每个涉及日期的 SQL 命令之前执行.如果您的查询通过一个类进行，那么这很容易实现.

This command should be executed before every SQL command involving dates. If your queries go thru a class, then this is easy to implement.

这篇关于MySQL时区更改?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！