I have 7 years of Weather data in a MYSQL database and still logging.
I want to use that data in Grafana.
But as the datebase is setup its logging date, hour and minute as separate rows.
And grafana seems to want date in unix_timestamp.
I can do this query to get the date, hour and minute to unxi_time_stamp
SELECT UNIX_TIMESTAMP(concat(date,’ ',time)) AS “time”, temperature as value FROM el.wd WHERE date >= ‘2019-05-01’
But do I have to do this for every query ?
Has enyone else done MYSQL and Grafana things before ?