blocks|key|616731|text|一个详尽的时区列表可以从MySQL网站上downloaded出来，作为数据库表导入到MySQL服务器中。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|616732|对于卡尔加里时间，您可以将UTC+offsets指定为|616733|set+time_zone+=+'-6:00';|code-block|syntax|javascript|616734|entityMap|0|LINK|mutability|MUTABLE|url|http://dev.mysql.com/downloads/timezones.html|1|http://www.timeanddate.com/worldclock/city.html?n=55^0|K|A|0|0|D|B|1|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@$A|V|B|W|1|X]]|C|$]]|$1|D|3|E|5|6|7|Y|8|@]|9|@$A|Z|B|10|1|11]]|C|$]]|$1|F|3|G|5|H|7|12|8|@]|9|@]|C|$I|J]]|$1|K|3|-4|5|6|7|13|8|@]|9|@]|C|$]]]|L|$M|$5|N|O|P|C|$Q|R]]|S|$5|N|O|P|C|$Q|T]]]]

An exhaustive list of timezones can be <a href="http://dev.mysql.com/downloads/timezones.html" rel="nofollow">downloaded</a> from MySQL's website as database tables that get imported into MySQL server.

For Calgary time you can specify <a href="http://www.timeanddate.com/worldclock/city.html?n=55" rel="nofollow">UTC offsets</a> as 

<pre><code>set time_zone = '-6:00';
</code></pre>

blocks|key|401764|text|唯一的答案：http://timezonedb.com/download|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|401765|使此答案有效的文本|401766|entityMap|0|LINK|mutability|MUTABLE|url|http://timezonedb.com/download^0|6|U|0|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@$A|O|B|P|1|Q]]|C|$]]|$1|D|3|E|5|6|7|R|8|@]|9|@]|C|$]]|$1|F|3|-4|5|6|7|S|8|@]|9|@]|C|$]]]|G|$H|$5|I|J|K|C|$L|M]]]]

The only answer:
<a href="http://timezonedb.com/download" rel="nofollow">http://timezonedb.com/download</a>

Text to make this answer valid

blocks|key|401804|text|应该注意，在MySQL启动时，MySQL时区变量的缺省设置是SYSTEM。系统值是从操作系统的全局time_zone环境变量中获取的。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|401805|通过提供以下命令行选项，可以在启动时将MySQL的默认时区变量初始化为不同的值：|401806|--default-time-zone=timezone|code-block|syntax|javascript|401807|或者，如果在选项文件中提供值，则应使用以下语法设置变量：|401808|--default-time-zone='timezone'|401809|如果您是MySQL超级用户，则可以在运行时使用以下语法从MYSQL>提示符设置系统time_zone变量：|401810|SET+GLOBAL+time_zone=timezone;|401811|MySQL还支持默认为全局time_zone环境变量值的各个会话时区值。要在会话期间更改会话时区值，请使用以下语法：|401812|SET+time_zone=timezone;|401813|为了查询现有的MYSQL时区设置值，您可以执行以下SQL来获取这些值：|401814|SELECT+@@global.time_zone,+@@session.time_zone;|401815|entityMap^0|0|0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|10|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|11|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|12|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|13|8|@]|9|@]|A|$]]|$1|K|3|L|5|F|7|14|8|@]|9|@]|A|$G|H]]|$1|M|3|N|5|6|7|15|8|@]|9|@]|A|$]]|$1|O|3|P|5|F|7|16|8|@]|9|@]|A|$G|H]]|$1|Q|3|R|5|6|7|17|8|@]|9|@]|A|$]]|$1|S|3|T|5|F|7|18|8|@]|9|@]|A|$G|H]]|$1|U|3|V|5|6|7|19|8|@]|9|@]|A|$]]|$1|W|3|X|5|F|7|1A|8|@]|9|@]|A|$G|H]]|$1|Y|3|-4|5|6|7|1B|8|@]|9|@]|A|$]]]|Z|$]]

It should be noted that the MySQL timezone variable's default setting is SYSTEM at MySQL startup. The SYSTEM value is obtained from the operating system's GLOBAL time_zone environment variable.
MySQL's default timezone variable can be initialised to a different value at start-up by providing the following command line option:
<pre><code>--default-time-zone=timezone
</code></pre>
Alternatively, if you are supplying the value in an options file, you should use the following syntax to set the variable:
<pre><code>--default-time-zone='timezone'
</code></pre>
If you are a MySQL SUPER user, you can set the SYSTEM time_zone variable at runtime from the MYSQL&gt; prompt using the following syntax:
<pre><code>SET GLOBAL time_zone=timezone;
</code></pre>
MySQL also supports individual SESSION timezone values which defaults to the GLOBAL time_zone environment variable value. To change the session timezone value during a SESSION, use the following syntax:
<pre><code>SET time_zone=timezone;
</code></pre>
In order to interrogate the existing MYSQL timezone setting values, you can execute the following SQL to obtain these values:
<pre><code>SELECT @@global.time_zone, @@session.time_zone;
</code></pre>

blocks|key|616826|text|您可以运行此查询来获取MySQL支持的时区的完整列表：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|616827|SELECT+Name
FROM+mysql.time_zone_name
ORDER+BY+Name|code-block|syntax|javascript|616828|(可在此页面找到：https://www.plumislandmedia.net/mysql/time-zones-mysql/)|offset|length|616829|entityMap|0|LINK|mutability|MUTABLE|url|https://www.plumislandmedia.net/mysql/time-zones-mysql/^0|0|0|9|1J|0|0^^$0|@$1|2|3|4|5|6|7|S|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|T|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|U|8|@]|9|@$I|V|J|W|1|X]]|A|$]]|$1|K|3|-4|5|6|7|Y|8|@]|9|@]|A|$]]]|L|$M|$5|N|O|P|A|$Q|R]]]]

You can run this query to get a complete list of the timezones MySQL supports:

<pre><code>SELECT Name
FROM mysql.time_zone_name
ORDER BY Name
</code></pre>

(Found on this page: <a href="https://www.plumislandmedia.net/mysql/time-zones-mysql/" rel="noreferrer">https://www.plumislandmedia.net/mysql/time-zones-mysql/</a>)

Is there an exhaustive list of MySQL Time Zones?

It seems that the valid values for <code>time_zone</code> in MySQL settings are dependent on the host Operating System but I have been unable to find a list of possible values.

I need the time to show Calgary local time.

MySQL Time Zones

数据库

服务器

MySQL

是否有详尽的MySQL时区列表？MySQL设置中time_zone的有效值似乎取决于主机操作系统，但我一直无法找到可能值的列表。我需要时间展示卡尔加里当地时间。

问MySQL时区
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问MySQL时区EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问MySQL时区
EN