17.10 - Period Value Constructor Syntax - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Date and Time Functions and Expressions

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1211-171K
Language
English (United States)
PERIOD (
  datetime_expression
  [, { datetime_expression | UNTIL_CHANGED | UNTIL_CLOSED } ]
)

Syntax Elements

datetime_expression
An expression that evaluates to a DATE, TIME, or TIMESTAMP value.
UNTIL_CHANGED

A DATE or TIMESTAMP value that is considered to be forever or until it is changed.

For PERIOD(DATE) types, UNTIL_CHANGED has a value of DATE '9999-12-31'.

For PERIOD(TIMESTAMP[(n)] [WITH TIME ZONE]) types, UNTIL_CHANGED has a value of TIMESTAMP '9999-12-31 23:59:59.999999 00:00'(with the precision truncated to the precision of the beginning bound and the time zone omitted if the beginning bound does not have a time zone).

UNTIL_CHANGED supports derived periods. See IS UNTIL_CHANGED/IS NOT UNTIL_CHANGED.

UNTIL_CLOSED

An ending bound for the Period value of a temporal table transaction-time column that indicates that the row is an open row.

UNTIL_CLOSED has a data type of TIMESTAMP(6) WITH TIME ZONE and a value of TIMESTAMP '9999-12-31 23:59:59.999999+00:00'.

For more information about temporal tables, see Teradata Vantage™ - Temporal Table Support, B035-1182.

UNTIL_CLOSED supports derived periods. See IS UNTIL_CLOSED/IS NOT UNTIL_CLOSED.