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#

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