Teradata Database provides the built-in capabilities that are required in a temporal database management system. Temporal data types and temporal statements facilitate creating applications that need to represent time and the information that changes over time.
|Temporal data types||The period data type represents an anchored duration of time.|
|Temporal column attributes||In addition to user-defined time, which can be represented by using DateTime data types such as DATE and TIMESTAMP, Teradata temporal table support adds the capability to add valid-time and transaction-time dimensions to tables, by means of temporal column attributes.|
|Temporal statements||Temporal variations of existing statements let you create and alter temporal tables, and query and modify data that changes over time.
Queries and modifications can include temporal qualifiers that reference a time dimension and act as criteria or selectors on the data. They affect only the data that meets the time criterion. Temporal DML statements can be generally qualified as: