Home / Companies / InfluxData / Blog / Post Details
Content Deep Dive

TL;DR InfluxDB Tech Tips - Time Range and Timestamps

Blog post from InfluxData

Post Details
Company
Date Published
Author
Regan Kuchan
Word Count
480
Company Posts That Month
9
Language
English
Hacker News Points
-
Post removed?
No
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.

Trends Found in this Post

No tracked trend matches for this post yet.

Use This Data

Use this post, company, and trend context to find content marketing opportunities, perform competitive analysis, or address product feature gaps via the Plushcap MCP server or the Plushcap API.