toInterval

Description

Returns an interval created from a numeric value and an optional time unit.

This function works with integers, decimals, positive, and negative values.

Syntax

Like many functions in DataPrime, toInterval supports two notations, function and method notation. These interchangeable forms allow flexibility in how you structure expressions.

toInterval(number: number, timeUnit?: timeunit): interval

(number: number).toInterval(timeUnit?: timeunit): interval

Arguments

Example

Use case: Add numeric duration to a timestamp to compute an end time

A log contains a start_time and a numeric duration in seconds. Convert the duration into an interval and add it to the timestamp.

{
  "start_time": 1728763337,
  "duration_seconds": 50
}

Example query

create end_time from addTime(start_time, duration_seconds.toInterval('s'))

create end_time from start_time.addTime(duration_seconds.toInterval('s'))

Example output

{
  "start_time": 1728763337,
  "duration_seconds": 50,
  "end_time": 1728763387
}