Menu
I am new to InfluxDB. I am querying data in admin ui. I see time as timestamp. Is it possible to see it formatted as date and time?
937
InfluxDB uses a host's local time in UTC to assign timestamps to data; if hosts' clocks aren't synchronized with NTP, the timestamps on the data written to InfluxDB can be inaccurate.
Basic GROUP BY time() queries rely on the time_interval and on the InfluxDB database's preset time boundaries to determine the raw data included in each time interval and the timestamps returned by the query.
Selecting tag keys in the SELECT clauseA query requires at least one field key in the SELECT clause to return data. If the SELECT clause only includes a single tag key or several tag keys, the query returns an empty response. This behavior is a result of how the system stores data.
The precision of the timestamp can be controlled to return hours (h), minutes (m), seconds (s), milliseconds (ms), microseconds (u) or nanoseconds (ns). A special precision option is RFC3339 which returns the timestamp in RFC3339 format with nanosecond precision.
You can select RFC 3339 formatting by entering the following command in the CLI:
precision rfc3339 To convert influxdb timestamp to normal timestamp you can type on console:
influx -precision rfc3339
Now try with your query it should work.
For more details follow link : https://www.influxdata.com/blog/tldr-influxdb-tech-tips-august-4-2016/
20
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
