timeshift interval: duration

Shifts each row forward or backward in time by adding a compile-time duration to the valid-from timestamp and, when the dataset has one, the valid-to timestamp.

The verb applies only to temporal datasets; a plain Table input is rejected at compile time.

If the input has metric alignment metadata, the alignment offset is updated modulo the step size so bucket boundaries stay consistent with the shifted timestamps.

Pipeline acceleration is propagated as insert-only relative to the input, like other operators that rewrite time columns.

To overlay several offset copies of the same series in one result instead of a single shift, use timewrap.

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 every row’s validity window forward by one hour so the same readings align to a later clock time.

timeshift -30m

Uses a negative duration to move validity timestamps half an hour earlier for backtesting or clock correction.