search

fr-ser / grafana-sqlite-datasource

Grafana Plugin to enable SQLite as a Datasource
Apache License 2.0
124 stars 17 forks source link

Time Conversion seemingly not working #62

Closed FabsCoding closed 2 years ago

FabsCoding commented 2 years ago

Describe the bug Time-Column does not get converted even though right format is supplied

To Reproduce Working from a file-based sqlite DB. Two columns:

Trying to setup a simple timeseries chart in Grafana. While Table-View shows correctly formated date and values, Graph-View reads "Data does not habe time field"

Screenshots image

image

It works with UNIX Timestamp but I am trying to get sub-second accuracy working, which according to the documentation should be working via Timestamps but I haven't had any luck so far.

fr-ser commented 2 years ago

Looking at the screenshot I see timestamps with a "Z" followed by an hour offset. This does not seem valid.