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';

(或格林尼治标准时间+ 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屋！