It turns out that MySQL has support for time zones, but doesn't have the necessary information to support named time zones out of the box. Once we have that sorted, there are some new and exciting ways we can query local times while storing them as UTC in MySQL. Read more…