For past events, I always beg people to somehow explicitly include the timezone in an encoding or storage, even if it's just UTC. i.e. never be tz naive! A tz naive PG column is a mess waiting to happen.