Hi folks,
I am trying to query an influxdb that has their timestamps in a nanosecond epoch format. When I set up the query on Grafana I get no data. Using Chronograf I was able to determine that the default query returns timestamps of 12-31-1969.
I’m guessing I need to change the default query in some way so that views the times properly but I haven’t been able to find out how to do that. Specifically I want to change the epoch value in this query…
Object
request:Object
method:"GET"
url:"api/datasources/proxy/1/query"
params:Object
db:"systems_telegraf"
q:"SELECT "last_established" FROM "bgp_neighbor_state_updated" WHERE time >= now() - 6h GROUP BY time(15s), "neighbor_address""
epoch:"ms"
data:null
precision:"ms"
response:Object
results:Array[1]
0:Object
Can someone help me fix this?