TL;DR InfluxDB Tech Tips - Convert Timestamps to Become Readable With Influx DB's CLI

By Todd Persen / Developer
Aug 04, 2016

Navigate to:

To learn about Flux Timestamps, check out this blog.

In this post we recap the week’s most interesting InfluxDB’s CLI issue with the ability to convert timestamps to become readable 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 command line interface 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?