Timestamp hourOf offset for CST

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 :wink:

And for future readers… use WITH TIMEZONE.

1 Like

Thanks @stefan_garnham and @6MM for the help on this! Great help as always! :smile: @reopelle.scott Let me know if this helps and if not, we’ll look into this further.

1 Like