SiriDB / siridb-server

SiriDB is a highly-scalable, robust and super fast time series database. Build from the ground up SiriDB uses a unique mechanism to operate without a global index and allows server resources to be added on the fly. SiriDB's unique query language includes dynamic grouping of time series for easy analysis over large amounts of time series.
https://siridb.com
MIT License
506 stars 48 forks source link

Implement option for Offset #185

Closed joente closed 1 year ago

joente commented 1 year ago

Implement an option for defining an offset when using aggregation functions.

For example:

select mean(1d) => offset(2h) from ...

The above will take the mean per day, with an offset of 2 hours. (for example when using a timezone of +2h)

Note that when using the offset, the daylight saving times are not honored