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.
How I've simplified my homelab by combining the ease of Unraid storage management with Portainer's GitOps feature to implement Infrastructure as Code.