So how are you solving the example in the article where they join on timestamps? Read both tables from the DB into the application?

I read raw data (UTC timestamps) from the db and timezone for user profile and calculate it on the fly.