search

influxdata / influxdb

Scalable datastore for metrics, events, and real-time analytics
https://influxdata.com
Apache License 2.0
28.86k stars 3.55k forks source link

Support Month in Duration Literal for Group by Operation #25004

Open dzaunerOci opened 5 months ago

dzaunerOci commented 5 months ago

Issue Summary: In InfluxQL, there's a lack of a built-in duration specifier for months, which makes it challenging to accurately group data into monthly intervals. Currently, users have to resort to approximations using days, which can lead to inaccuracies, especially when dealing with varying month lengths and leap years.

Proposal: I propose adding a month duration literal to InfluxQL to provide users with a more intuitive and precise way to specify monthly intervals in queries. This enhancement would streamline data analysis and reporting workflows, making it easier for users to work with temporal data at the monthly level.

Suggested Syntax: A suggested syntax for the month duration literal could be 1mo, following the conventions used in other date-time libraries and query languages.

sarthak0906 commented 2 months ago

Is anyone working on this issue? I am looking to start contributing and can look into this with some guidance.

shrx commented 1 month ago

related https://github.com/influxdata/influxdb/issues/3991