TIMESTAMP_COLUMN
Description
TIMESTAMP_COLUMN allows to refer the timestamp column of an activity table in the data model without using the exact column name.
Syntax
TIMESTAMP_COLUMN ( [ expression ] )
When an expression that involves a column of an activity table is passed as an argument, the timestamp column of that activity table is referenced.
When no argument is passed, the timestamp column of the default activity table is referenced.
When a table reference is passed as an argument, the timestamp column of that activity table is referenced.
Examples
[1] In this example, the data model contains one activity table. Using a column reference as the input expression, we refer to the TIMESTAMP column of the related activity table: | ||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
|
[2] In this example, the data model contains one activity table. By passing no arguments to the | ||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
|
[3] In this example, MERGE_EVENTLOG is used to combine two activity tables into one. We can then use | ||||||||||||||||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||||||||||||||
|
[4] In this example, the data model contains one activity table. Using a table reference as the input expression, we refer to the TIMESTAMP column of the related activity table: | ||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||
|