How do you make simple_form timezone have values which are valid for postgres

Question

In SimpleForm you can create a timezone input: ``` = simple_form_for @user do |f| = f.input :time_zone, label: 'My time zone' ``` However the values which simple form puts into the form are not valid for Postgres: ``` ... ``` The actual values need to correspond with the hash: ``` {"International Date Line West" => "Pacific/Midway", "Midway Island" => "Pacific/Midway", "American Samoa" => "Pacific/Pago_Pago", "Hawaii" => "Pacific/Honolulu", "Alaska" => "America/Juneau", "Pacific Time (US & Canada)" => "America/Lo…

Accepted Answer

Rails time zones are an oversimplification of the standard TZDB. If you can avoid using them, I would use the full IANA TZDB zones instead. In Ruby, this is easiest with the TZInfo Gem.

If you are stuck with them, then you can use the `MAPPING` constant from `ActiveSupport::TimeZone`, as shown in these docs. That will let you correlate the Rails identifier back to the normal region/locality format.

See also the section at the bottom of the timezone tag wiki on Rails time zones.

How do you make simple_form timezone have values which are valid for postgres

Solution

Problem