row_timestamp

Description

Returns the value of the timestamp column for each row.

Behavior differs by the type of dataset:

• for Event datasets, the “timestamp” column is used

• for Interval or Resource datasets, the “Valid From” column is used

• for Table datasets, null is used

Return type

timestamp

Domain

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

Categories

• Time

Usage

row_timestamp()

Examples

make_col time_taken:if_null(row_end_time() - row_timestamp(), 0s)

Create a column time_taken that is the duration of the state within the row.

Aliases

row_start_time