A period is an anchored duration that represents a set of contiguous time granules. A period has a beginning bound (defined by the value of a beginning element) and an ending bound (defined by the value of an ending element). The representation of the period extends from the beginning bound up to but not including the ending bound.
Teradata supports the following Period data types:
- PERIOD(DATE)
- PERIOD(TIME)
- PERIOD(TIMESTAMP)
PERIOD(TIME) and PERIOD(TIMESTAMP) can be specified with optional fractional seconds, for example PERIOD(TIME(6)), and optional time zone, for example PERIOD(TIMESTAMP WITH TIME ZONE).