When I use the hourOf timestamp it shows the UTC. What would the offset be for CST? Is the offset in second, ms, hours?
It appears to be in Milliseconds and the answer is hourOf(timestamp - 21600000) to put hourly buckets into the correct CST timeframe.
Hi @reopelle.scott - I think my answer on your previous post will also solve this question
And for future readers… use WITH TIMEZONE.