TL;DR InfluxDB Tech Tips - Convert Timestamps to Become Readable With Influx DB's CLI
By Todd Persen / Aug 04, 2016 / Tech Tips
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.
Question: How do you make InfluxDB’s CLI return human readable timestamps?
Instead of this:
name: clothes --------- time percent_cool 892482496000000000 0.5
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.
- Looking for InfluxDB clustering on your infrastructure? Get started with InfluxDB Enterprise Beta, now available for evaluation.
- Download and get started with InfluxDB 1.0 Beta 3
- Schedule a FREE 20 minute consultation with a Solutions Architect to review your InfluxDB project
- Attend one of our FREE virtual training seminars.