Hello everyone,
-
What Grafana version and what operating system are you using?
-
Grafana 8.3.4
-
Debian 11
-
-
What are you trying to achieve?
Create a table with a postgresql query
-
What happened?
i’m using this query to show some data from a table.
select dop.operation_date,
dpw.platform_name as plateform,
df.fiat_name as fiat,
dop.amount_spent
from table1 dop
inner join table2 df on df.id = dop.fiat_id
inner join table3 dpw on dpw.id = dop.plateform_id
order by dop.operation_date desc, dop.creation_date desc
limit 10
The first column operation date is showing this way on grafana :
But the column in my table in Postgresql is in DATE format without any hour, minute, second. I don’t know from where grafana could find those values for the hour.
I checked with that to make sur that my data in my database was in good format
SELECT date_part('hour',operation_date)
from my_table;
and everything is ok. I got a nice 0 for all the lines. Not any 1 or 2 as it is showed in grafana.
- What did you expect to happen?
My data on grafana should be the same as what they are in my BDD, like this :
Thanks a lot for your help to a fresh newbie on grafana.