mysql - 无法将mysql时区设置为马德里

Question

根据这个question关于如何在 mysql 中设置时区和这个时区 list ，我认为这应该有效:

SET time_zone = 'Europe/Madrid';

但这就是 sqlBuddy 记录的内容:

The following errors were reported:Unknown or incorrect time zone: 'Europe/Madrid'

Answer 1

确保已填充时区信息表。来自 mysql :

The value can be given as a named time zone, such as 'Europe/Helsinki', 'US/Eastern', or 'MET'. Named time zones can be used only if the time zone information tables in the mysql database have been created and populated.

尽管我个人更喜欢以 UTC 格式存储所有日期。我发现它使推理变得简单得多，尤其是在引入夏令时时。