row_timestamp

Aliases: row_start_time.

row_timestamp() -> timestamp

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

Domain

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

Categories

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.