Grafana v5.3.0-beta1 (commit: e05033a) The preset time frame (Quick Ranges) is generating an incorrect date in the query, 5 hours into the future. The timezone on my PC, and MySQL db and Grafana (browser tz) is correct. Yet I must use ‘last 6 hours’ to see any data. Setting preset to 5 minutes ca…

Make sure your time is synced across your computer and server. And that your MySQL date field is stored in UTC

Hey @torkel , Thanks for the prompt reply! The MySQL server, my PC, and Grafana server are synced. Fwiw, I use a practically identical setup elsewhere and I don’t have any issues. Do you think it’s possibly just a bug in the version I’m using? Grafana v5.3.0-beta1 (commit: e05033a) If so, could y…

[image] itcas: It’s showing: BETWEEN ‘2018-09-22T04:28:23Z’ AND ‘2018-09-22T04:33:23Z’ Instead of: BETWEEN ‘2018-09-22T021:28:23Z’ AND ‘2018-09-21T23:33:23Z’ The date sent over the wire shown in query inspector is in UTC. You cannot compare that to the tooltip date as that is showin in local…

How should or can I remedy this? To me this still appears to be a bug with the latest version. I’m fine with downgrading, I just can’t find the proper documentation on how to do that. Reasoning: I’ve confirmed the other setup, which is working properly, is identical to this one; same timezone, dat…

I am unable to replicate this, last 5min generates the correct SQL time range filter. Are you sure you convert the UTC time you see to your local time? The timefilter you see in the query is in UTC and the tooltip you see in the timepicker is local time.

[image] itcas: The MySQL server, my PC, and Grafana server are synced. All are running UTC?

Hi, I have the same problem, in the previous versions everything worked fine, but in version 5.3 it does not. maybe I have something wrong configured, but I would like to know how to remedy it and thus be able to use version 5.3. This is reported in #13205

Update: I think you get the following behavior due to the following changes: https://github.com/grafana/grafana/issues/11619 Our intention have never been to support anything else than UTC on Grafana and UTC in database/storing timestamps in actual UTC time in database. Unfortunately this have work…

–Before– Grafana: V5.2.4 Mysql: @@version: 5.7.19 @@system_time_zone: UTC @@global.time_zone: America/Bogota Dashboards timezone: Default –After– Grafana: V5.3.beta1 Mysql: @@version: 5.7.19 @@system_time_zone: UTC @@global.time_zone: America/Bogota Dashboards timezone: Default If …

Preset time-frames broken - shows 'no data points' - date is 5 hours ahead

Grafana

anon34853223 September 25, 2018, 7:41am 9

Could you give us some more information about what version worked before 5.3?

Topic		Replies	Views
MySQL: Generated Query does wrong time filtering MySQL mysql	11	2524	November 20, 2018
Grafana graphs show UTC data in the datasource MySQL mysql	2	892	October 29, 2018
Weird timezone problems Dashboards	25	8716	July 5, 2023
Time Zone no work - grafana no anda Grafana time-selection	5	110	June 8, 2025
GMT - 3 Time zone - Help Configuration	14	4735	October 2, 2020

Preset time-frames broken - shows 'no data points' - date is 5 hours ahead

Related topics