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.
Period types are a Teradata extension to the ANSI SQL:2011 standard.
PERIOD(DATE) [ attribute [...] ]
- Appropriate data type, column storage, or column constraint attributes. See Core Data Type Attributes and Storage and Constraint Attributes for specific information.
- The following data type attributes are supported for a PERIOD(DATE) column:
- NULL and NOT NULL
- FORMAT 'format string'
- DEFAULT NULL
- DEFAULT value
- WITH DEFAULT
- For more information on these data type attributes, see Default Value Control Phrases and Data Type Formats and Format Phrases.
- The following data type attributes are not supported for a PERIOD(DATE) column:
- DEFAULT USER
- DEFAULT DATE
- DEFAULT TIME
- DEFAULT CURRENT_DATE
- DEFAULT CURRENT_TIME[(n)]
- DEFAULT CURRENT_TIMESTAMP[(n)]
- UPPERCASE or UC
- CASE_SPECIFIC or CS
- CHARACTER SET