Usage Notes - Teradata Vantage - Analytics Database

SQL Date and Time Functions and Expressions

Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2023-10-30
dita:mapPath
cpk1628111786971.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
pxz1544241488545
lifecycle
latest
Product Category
Teradata Vantageā„¢

When a row is created in a temporal table that has a system-time or transaction-time dimension (column), Vantage sets the ending bound of the column to UNTIL_CLOSED and the row is considered open. When the row is closed, Vantage sets the ending bound value to the closing timestamp.

IS UNTIL_CLOSED evaluates to true if the ending bound of the specified column is the maximum timestamp value, 9999-12-31 23:59:59.999999+00:00.