Where the timezones comes from?
Added by Eugene Hutorny about 12 years ago
Our Redmine 1.2 instance lists Kiev timezone as '(GMT+2:00) Kyev' (which is wrong)
and the value is stored as 'Kyev'.
This value neither come from OS
[root@sandbox ~]# ls /usr/share/zoneinfo/Europe/K* /usr/share/zoneinfo/Europe/Kaliningrad /usr/share/zoneinfo/Europe/Kiev
nor from DBMS
select name from pg_timezone_names where name like '%K%v' right/Europe/Kiev Europe/Kiev posix/Europe/Kiev
redmine.org instance lists Kiev as '(GMT+2:00) Kyiv' which is politically correct
but still, its value is not directly convertible to a value valid for OS or DBMS.