TL;DR InfluxDB Tech Tips – August 4, 2016

Todd Persen — August 4, 2016

In this post we recap the week’s most interesting InfluxDB and TICK-stack related issues, workarounds, how-tos and Q&A from GitHub, IRC and the InfluxDB Google Group that you might have missed.

Human-readable timestamps in the CLI

Question: How do you make InfluxDB’s CLI return human readable timestamps?

Instead of this:

name: clothes
time                percent_cool
892482496000000000  0.5

Return this:

name: clothes
time                   percent_cool
1998-04-13T15:48:16Z   0.5

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

Check out our docs for more useful CLI options.

For more InfluxDB tips, see our Frequently Asked Questions page and feel free to post your questions in the InfluxDB users group.

What’s next?