Found row with no time value

Grafana Time Series Panel
1

I have a table with 2 columns:

When I add a table panel with SQL statement SELECT * FROM xiaomi_th_alex_temperature_0026
I get: (which is correct)

But I would like to have all this data in a graph, I tried:

SELECT
UNIX_TIMESTAMP(time) as time_sec,
value as value
FROM xiaomi_th_alex_temperature_0026
WHERE $__timeFilter(time)
ORDER BY time ASC

But I receive the following error: Found row with no time value

I suppose the date format isn’t correct, but don’t know what do modify.

2

Found a solution, don’t know if this the proper way…

SELECT
UNIX_TIMESTAMP(DATE_FORMAT(time,“%Y-%m-%d %H:%i:%s”)) as time_sec,
value
FROM
xiaomi_th_alex_temperature_0026

I found out that my datetime format is ISO8601 with time zone Z (127) and it should be possible to format this but that didn’t worked. (see How to convert SQL Server's timestamp column to datetime format - Stack Overflow)