MySQL timezone and timestamp calculations

MySQL timezone and timestamp calculations for when you don't have access
to the timezones in MySQL.