What Grafana version and what operating system are you using? Raspberry pi / Grafana v12.3.1 (0d1a5b4420)
-
What are you trying to achieve? retrieve the max of values stored in postgresDB for the current month starting 01.01.2026
-
How are you trying to achieve it? Using date_trunc(‘month‘,ts)
-
What happened? The trunc command returns a date in the previous year for timestamps 2026-01-01 00:30:00 even though the postgress database is using a table where the ts is defined as timestamptz
-
What did you expect to happen? The same result as returned in DBeaver (which is giving back the date_trunc(‘month’, 2026-01-01 00:30:00 ) being 2026-01-01 00:00
-
Can you copy/paste the configuration(s) that you are having problems with?
-
Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were. N0
