When I choose a time range for example Today, this month, etc grafana adds by default one day before. For example :
today (22-03-2022)= BETWEEN ‘2022-03-21T23:00:00Z’ AND ‘2022-03-22T22:59:59.999Z’
this month (the month of 03 2022)= BETWEEN ‘2022-02-28T23:00:00Z’ AND ‘2022-03-31T22:59:59.999Z’
This gives me incorrect results.
So I want to know if I can configure grafana time range to eliminate the added day
Can you confirm that both Grafana’s time settings and the timezone for your postgres db are set to UTC? Things work best when everything is set to UTC…