Running Grafana v8.5.3 locally installed on a raspi 4. Running MySQL database. I have a column in the database that is datatime format yyyy-mm-dd hh:mm:ss.ssssss. In a table display of this data in Granfana, Granfana changes the hh part of the timestamp. It’s changed the time by exactly 5 hours?, It’s like adding 5 hours to my datatime field before its displayed. I"m just trying to dump the data from the table. No conversion or anything.
What is going on?
I’ve added 2 images to this post and also I’m new to Grafana. !
To the best of my understanding, your correct, datetime is not stored as UTC, where as Timestamp is. I"m using datetime Time zone is set to Americas, Chicago which is Central Daylight Savings Time.
MySQL doc states
In short, “ MySQL convertsTIMESTAMPvalues from the current time zone to UTC for storage, and back from UTC to the current time zone for retrieval. (This does not occur for other types such asDATETIME.)”
In other words, timezone information is lost in DATETIME columns. This may not be a huge problem if your use cases regarding timezone are homogeneous.
So is Grafana doing some type of conversion thinking it’s UTC format?
!
