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 0:Object
Can someone help me fix this?