timeshift interval: duration

Shifts the timestamps of rows ahead in time by the specified interval. If the interval is negative, the intervals are shifted back in time. If used with non-temporal verbs (exists, follow, etc.), timeshift will return incomplete data.

Categories

• Metadata
• Metrics

Accelerable

timeshift is always accelerable if the input is accelerable. A dataset that only uses accelerable verbs can be accelerated, making queries on the dataset respond faster.

Examples

timeshift 1h

Shifts the timestamps of all rows ahead by 1 hour, e.g. a row whose timestmap is 12pm will now be 1pm.

timeshift -1h

Shifts the timestamps of all rows back by 1 hour, e.g. a row whose timestmap is 12pm will now be 11am.