Date format issue (solved)

1

Hi, new to Grafana so pls, bear with me.

I want to create a simple graph from queries A & B:

SELECT temp, saved AS 'time' FROM dht ORDER BY saved ASC (or SELECT temp, UNIX_TIMESTAMP(saved) AS 'time' FROM dht ORDER BY saved ASC)
SELECT humidity, saved AS 'time' FROM dht ORDER BY saved ASC (or SELECT humidity, UNIX_TIMESTAMP(saved) AS 'time' FROM dht ORDER BY saved ASC)

I don’t get any errors nor I get data in the graph grid.

Do I have a datetime format issue?

Here’s a basic output from mysql:

|“21.75”|“2020-08-11 19:03:40”|
|“22.88”|“2020-08-11 19:13:40”|
|“23.44”|“2020-08-11 19:23:40”|
|“23.72”|“2020-08-11 19:33:40”|
|“23.86”|“2020-08-11 19:43:40”|

2

Never mind. I was storing temp and humidity in string format. Converting them to decimals, solved my problem.