Can aggregates be made to scale across days?

TimescaleDB and PostgreSQL
1

It seems like the default behavior for time aggregates is to stay within the 24 hour time period of the same day. Is it possible to change it?

More specifically, I have data that starts at 10PM for the day/week and a 4 hour time aggregate makes the first row start at 8PM. I want the first row to start on the next day at 2AM which would make every day forward have the last row at 10PM and the first for the day at 2AM.

2

Hi @welchums , have you checked you can use time_bucket with time zone?

Is it a time zone issue? you can also put the origin date in the time_bucket, see more here: Timescale Docs