That seems like overkill for most apps. Better to just store the date/time without timezone, and either the windows or linux timezone name of the location (whic

That seems like overkill for most apps. Better to just store the date/time without timezone, and either the windows or linux timezone name of the location (which has far more specificity than the ISO 8601 offset). Then calculate the actual time on the fly when pulling it out of the DB. No mucking around with IANA databases, everything's easy to program, server usually keeps itself up-to-date.