I’ve often found it helpful to be able to reference timezones for humans using an app. E.g. we have a database record for a person or a store location and we want to know what timezone they are in.
When I use Timex, I see that it updates “tzdata” constantly in little files named something like 2018e.ets
. Is there any way I can search or reference that data? For BI/UI/transparency purposes, I’d prefer to have it available in a relational database, but I’ve never been able to figure out how to do that. Even MySQL had internal timezone tables somewhere. Does anyone know how to get at that data? E.g. say I want to do an auto-complete on a form field or reference the timezone as a foreign key constraint. Possible?