I have an issue with the Grafana interpretation of the time column from an SQL database. The table in the database contains a Timestamp column with the format YYYY-MM-DD HH:MM:SS (first image) which seems to work fine when imported into Grafana directly as a table, however to create a graph I need to specify Timestamp as “time”. When I do this the timestamp automatically converts into millisecond epoch time (second image).
As a result of this it seems like Grafana cannot properly graph the data, with “No data” shown for queries where data definitely exists in the database. Is there some way to specify the date format in Grafana?