What Grafana version and what operating system are you using?
What are you trying to achieve?
Create a table with a postgresql query
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.