Human-readable timestamps in the InfluxDB CLI

Entwicklung / Development Daten / Data
1

Q&A

Question: How do you make InfluxDB’s CLI return human readable timestamps?
Answer: When you first connect to the CLI, specify the rfc3339 precision:

$ influx -precision rfc3339

Alternatively, specify the precision once you’ve already connected to the CLI:

$ influx
Connected to http://localhost:8086 version 0.xx.x
InfluxDB shell 0.xx.x
> precision rfc3339

– via: Convert Timestamps to Become Readable With Influx DB's CLI | InfluxData

Example

> SELECT * FROM gps LIMIT 1

time                 latitude     longitude    altitude speed
----                 --------     ---------    -------- -----
2018-09-13T12:34:24Z 40.031490667 -0.002910167 36.3     119.1384