Charts are not built for a time range other than the last 6 hours

Grafana Dashboards
1

I have a table machines_records_full in MySQL

describe machines_records_full;

describe

I’m trying to build a graph in Grafana for the last 6 hours:

SELECT
  time AS "time",
  lamp,
  tube
FROM machines_records_full
WHERE
  time BETWEEN FROM_UNIXTIME($__unixEpochFrom()) AND FROM_UNIXTIME($__unixEpochTo()) AND
  machine_id = 1
ORDER BY time;

Screenshot_3
Screenshot_32490×974 156 KB

Everything works well

But when I select a different time period, for example, for the last 15 minutes, the graph is not displayed

Screenshot_4
Screenshot_42550×973 136 KB

Although the request to MySQL returns data:

Screenshot_5
Screenshot_51271×969 200 KB

2

is your time column utc?

1 Like
3

Indeed, I solved the problem using the time zone in the request in Grafana

SELECT
  CONVERT_TZ(time, '+03:00', '+00:00') AS "time",
  lamp,
  tube
FROM machines_records_full
WHERE
  time BETWEEN FROM_UNIXTIME($__unixEpochFrom()) AND FROM_UNIXTIME($__unixEpochTo()) AND
  machine_id = 1
GROUP BY time
ORDER BY time;
1 Like
5

will that work for daylight savings time? +03:00 seems very static
Should it not be something like this?

convert_tz(time,'US/Eastern','UTC') and specifying your TZ