Company
Date Published
Author
Regan Kuchan
Word count
480
Language
English
Hacker News points
None

Summary

In this post, we recap the week’s most interesting InfluxDB and TICK-stack related issues, workarounds, time range and timestamps how-tos and Q&A from GitHub, IRC and the InfluxDB Google Group that you might have missed. By default, InfluxQL queries cover the time range between epoch 0 and now(). To query data that occurs in the future, you can use `now() + x` to specify a specific date or `156w` to span 156 weeks from now. The functions `first()` and `last()` return epoch 0 by default, but workarounds using `LIMIT` and sorting queries can be used to get the first and last timestamps in your data. InfluxDB version 0.13 will have a new function called `elapsed()`, which returns the difference between subsequent timestamps in a single field.