Time and continuous aggregates

URL: llms-txt#time-and-continuous-aggregates

Contents:

• Declare an explicit timezone
• Integer-based time

Functions that depend on a local timezone setting inside a continuous aggregate are not supported. You cannot adjust to a local time because the timezone setting changes from user to user.

To manage this, you can use explicit timezones in the view definition. Alternatively, you can create your own custom aggregation scheme for tables that use an integer time column.