Absolute time range

Grafana Dashboards
1

Hi,
I want my table to display data based on the Absolute time range setting, but I’m having difficulty achieving it because currently it shows the entire MySQL table from the beginning to the end, regardless of the time I set in the Absolute time range.
My querry

SELECT
    CONVERT_TZ(Laikas, @@SESSION.time_zone, '-04:00') AS time,
    stulpelis2, Latitude, longitude
FROM
    asedlt_8622.testukas
ORDER BY
    Laikas DESC;

I try this, but is not working

SELECT
    CONVERT_TZ(Laikas, @@SESSION.time_zone, '-04:00') AS time,
    stulpelis2, Latitude, longitude
FROM
    asedlt_8622.testukas
WHERE
    Laikas >= $__timeFrom() AND Laikas <= NOW()
ORDER BY
    Laikas DESC;

How fix it?

grafena22
grafena221917×953 271 KB

2

Check the docu for that function

3

I tryed this


SELECT
    CONVERT_TZ(Laikas, @@SESSION.time_zone, '-04:00') AS Time,
    stulpelis2, Latitude, longitude
FROM
    asedlt_8622.testukas
 WHERE
    Laikas BETWEEN $__timeFrom() AND $__timeTo()

Result is same :frowning: No data