15.10 - Preface - Teradata Database

Teradata Database ANSI Temporal Table Support

prodname
Teradata Database
vrm_release
15.00
15.10
category
Programming Reference
featnum
B035-1186-015K

ANSI Temporal Table Support describes the concepts fundamental to understanding Teradata Database support for ANSI temporal (time-aware) tables and data. This manual includes SQL language reference material and examples specific to the practical creation and manipulation of ANSI-compliant temporal tables.

For information on Teradata’s proprietary temporal tables, which have different capabilities than ANSI-compliant temporal tables, see Temporal Table Support. For more information on the differences between the two temporal paradigms, see “ANSI Temporal and Teradata Temporal” on page 24

Note that most temporal qualifiers and query syntax that is used with Teradata’s proprietary temporal tables can be used also on ANSI temporal tables.