search

influxdata / influxdb-java

Java client for InfluxDB
MIT License
1.17k stars 476 forks source link

Support Month in Duration Literal #1006

Open dzaunerOci opened 2 months ago

dzaunerOci commented 2 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.

majst01 commented 2 months ago

This must be changed in the influxdb database, not the java client