Support Month in Duration Literal

[dzaunerOci]

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]

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