15.00 - TEMPORAL_DATE - Teradata Database

Teradata Database SQL Functions, Operators, Expressions, and Predicates

Product
Teradata Database
Release Number
15.00
Content Type
Programming Reference
Publication ID
B035-1145-015K
Language
English (United States)
Last Update
2018-09-24

TEMPORAL_DATE

Purpose  

Returns the current transaction date where the evaluation is based on the session time zone.

Syntax  

Result Type and Attributes

The result data type, format, and title for TEMPORAL_DATE are as follows:

 

Data Type

Format

Title

DATE

Default format for the DATE data type when the Dateform mode is set to IntegerDate.

For details on default formats, see “Data Type Formats and Format Phrases” in SQL Data Types and Literals.

Date

Usage Notes  

The value of TEMPORAL_DATE is the same for all requests submitted in a single transaction.

The system uses the session time zone to evaluate TEMPORAL_DATE.

When TEMPORAL_DATE appears in a CHECK constraint or DEFAULT clause, the result value is evaluated when the request applies the CHECK constraint (during an insert or update) or when the request uses the DEFAULT value for a given column.

For information on using TEMPORAL_DATE with temporal tables, see Temporal Table Support.

Restrictions

TEMPORAL_DATE is not supported in a partitioning expression for the PARTITION BY clause that defines a partitioned primary index.