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(TIMESTAMP[(n)] WITH TIME ZONE) column records the beginning and ending bounds in UTC form in the same manner as exists for a TIMESTAMP WITH TIME ZONE column.
ANSI Compliance
Period types are a Teradata extension to the ANSI SQL:2011 standard.