Recently I found myself working with timezone translations in a Rails app. However, I had never loaded my local MySQL with the timezone information which led to the conversions’s returning null.

If you haven’t yet loaded your MySQL time zone tables on your Mac, here’s a step by step for doing so from your Mac’s own time zone files.