I’m running graphana 5.3 and when i use the variable “$__timeFilter(column)”
I have an issue, with the time generated.
This is the generated sql code :
select * from ocum.volumehistorymonth
where volumeID = “2959” and periodEndTime BETWEEN ‘2018-11-05T09:31:13Z’ AND ‘2018-11-12T09:31:13Z’ <-- this indeed conform to what grafana help explained
The query is correct, i test the query generated by grafana directly on my database but the “T” and “Z” are generated warning (), my column periodEndTime is type : TIMESTAMP and so the date stored are in the format : “2018-11-06 02:00:00”
So the first question is : do we have a setting where we could avoid having this “Z and T”?
But as the generated query is returning correct value (even if i have warning) i’m not sure why inside grafana i get this error : “Found no column named time or time_sec”
Any help welcome