I'm a passionate CTO who bifurcates his love between great software development and leading others in their continuous improvement journeys
A datetime with an offset isn't a timezone. Here's how we use PostGIS and the Timezone Boundary Builder dataset to turn a driver's GPS coordinates into the IANA zone their planner actually needs to see.