PERIOD(TIME) Data Type | Data Types and Literals | VantageCloud Lake - PERIOD(TIME) Data Type - Teradata Vantage

Teradata® VantageCloud Lake
Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
ft:locale
en-US
ft:lastEdition
2024-12-11
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905

A data type that has two DateTime elements associated with it.

DateTime Element Definition
Beginning Beginning bound of a period.
Ending Ending bound of a period.

The beginning bound is inclusive, and the ending bound is exclusive; that is, the DateTime range starts at the beginning bound and extends up to but not including the ending bound.

A PERIOD(TIME[(n)]) column records the beginning and ending bounds in UTC form in the same manner as exists for a TIME column.

The PERIOD(TIME[(n)] data type is only supported on the Block File System on the primary cluster. It is not available for the Object File System.

ANSI Compliance

Period types are a Teradata extension to the ANSI SQL:2011 standard.

Related information