aggregating by the users timezone in Postgres

Question

my daily rollups are off because everything is stored UTC. how do you group by the users local day correctly in SQL?

Nina Alvarez · Accepted Answer

you are closer than you think. it is the ordering — do the setup step before the call.

Tariq Hassan · Answer

this bit me too. short version: it is a timing thing. move it into the load step.

2 answers