Convert mysql datetime to timestamp to create a timeseries chart

1

Hi,

I am new to Grafana and facing problem with datetime conversion to timestamp (MySQL). I am trying to create a timeseries chart.

Screen Shot 2020-03-09 at 12.05.23 PM
Screen Shot 2020-03-09 at 12.05.23 PM1468×720 46 KB

I looked into similar topics for answers but failed to achieve the required result.
One of the solutions i tried:
SELECT
UNIX_TIMESTAMP(date_insert) as time_sec,
temperature as value,
‘temperature’ as metric
FROM meteo
WHERE $__timeFilter(date_insert)
ORDER BY date_insert ASC

Thanks!