A data type that has two DateTime elements associated with it.
The DateTime element... | Specifies... |
---|---|
beginning | the beginning bound of a period. |
ending | the 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 currently for a TIME column.
ANSI Compliance
Period types are a Teradata extension to the ANSI SQL:2011 standard.
Syntax
PERIOD(TIME [ ( fractional_seconds_precision ) ] ) [ attribute [...] ]
Syntax Elements
- fractional_seconds_precision
- A single digit representing the number of significant digits in the fractional portion of the SECOND field.
- attributes
- Appropriate data type, column storage, or column constraint attributes. See Core Data Type Attributes and Storage and Constraint Attributes for specific information.