Problem Time Range "Now"

Grafana Configuration
1

Hello together,

sorry i am new. Tried a lot since two day. Search doesnt help, because i am not sure what to search… and everything found didnt help.

My Data in “table view” is 2h ahead.
I adjusted everything around, but if i watch the graphs by “relative time” e.g. " -5 min till now" it shows me the data “my time” -5 min → 2h back from data.

Here my data in mariaDB:

grafik
grafik567×606 52.1 KB

Here my data in grafana:

grafik
grafik1330×341 21.2 KB

I could live with that, but the problem is, grafana is doing something with "Time + Value “Bezugsleistung”
It doesnt show me the write value in the graph. I think its the problem of the timeshift…
How is it possible to store right Time in “table view” = grafana?

Thankyou

2

Welcome @martinhassinger

Sounds like your date column is not UTC

Use a mariadb function to convert it to UTC

3

Thank you.
I read this before, but not sure how to manage.

Here is my Timezone (thats the point):
grafik

I made a new field (8) for “Zeit UTC”, but cant choose something like Datetime UTC…
Can u tell me how to fill new field with time UTC?

grafik
grafik885×274 21.2 KB

Thanks a lot

4

That ia beyond grafana. I would consult mariadb documentation

Instead of changing or adding table column qouls be easier to use a function like this

convert_tz
Example

convert_tz(createddate,'America/New_York','UTC') as time,

CONVERT_TZ - MariaDB Knowledge Base.