Temporal Behavior - Advanced SQL Engine - Teradata Database

Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Published
January 2021
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
ynh1604715438919.ditamap
dita:ditavalPath
hoy1596145193032.ditaval
dita:id
B035-1102
lifecycle
previous
Product Category
Teradata Vantage™

Purpose

Determines the default temporal behavior for temporal DDL, queries and DML statements.

This field should be changed only under the direction of Teradata Support Center personnel or field engineers.

Field Group

General

Valid Settings

Setting Description
0 Default temporal session qualifier is CURRENT VALIDTIME AND CURRENT TRANSACTIONTIME, compatible with Teradata’s original implementation of temporal tables and syntax documented in Teradata Vantage™ - Temporal Table Support , B035-1182 .
1 Default temporal session qualifier is ANSIQUALIFIER, required to use ANSI-compliant temporal tables documented in Teradata Vantage™ - ANSI Temporal Table Support , B035-1186 .

Default

  • 0 for systems that were upgraded from releases prior to Teradata Database Release 15.0, and that had the Teradata Temporal feature enabled.
  • 1 for all other systems.

Changes Take Effect

After the DBS Control Record has been written.

Related Topics

For more information on temporal tables and syntax, see Teradata Vantage™ - ANSI Temporal Table Support , B035-1186 and Teradata Vantage™ - Temporal Table Support , B035-1182 .