Project

General

Profile

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.