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.