17.05 - Syntax - Teradata Database

Teradata Vantage™ - Temporal Table Support

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
17.05
created_date
June 2020
category
Programming Reference
featnum
B035-1182-170K
SET SESSION TTGRANULARITY TO { LOGICALROW | REQUEST | TRANSACTION }
LOGICALROW
Row is timestamped with the time the row is processed by the AMP.
REQUEST
Row is timestamped with the time the request is submitted.
TRANSACTION
Row is timestamped with the time when the first non-locking reference is made to a temporal table, or when the built-in function TEMPORAL_TIMESTAMP is first accessed during the transaction.