duration

Description

Convert a number or timestamp, or a time interval, to a duration. Numbers are assumed to be nanoseconds

Return type

duration

Domain

This is a scalar function (calculates a single output value for a single input row.)

Categories

• Time

Usage

duration( timestamp )

Argument	Type	Required	Multiple
timestamp	timestamp	Required	Only one

duration( number )

Argument	Type	Required	Multiple
number	numeric	Required	Only one

duration( start_timestamp, end_timestamp )

Argument	Type	Required	Multiple
start_timestamp	timestamp	Required	Only one
end_timestamp	timestamp	Required	Only one