Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Support Month in Duration Literal for Group by Operation #25004

Open
dzaunerOci opened this issue May 15, 2024 · 0 comments
Open

Support Month in Duration Literal for Group by Operation #25004

dzaunerOci opened this issue May 15, 2024 · 0 comments

Comments

@dzaunerOci
Copy link

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.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant