Syntax
PERIOD(TIME [ ( fractional_seconds_precision ) ] WITH TIME ZONE )
[ attribute [...] ]
Syntax Elements
- fractional_seconds_precision
- A single digit representing the number of significant digits in the fractional portion of the SECOND field.
- Values for fractional_seconds_precision range from 0 to 6 inclusive.
- The default precision is 6.
- attributes
- 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(TIME WITH TIME ZONE) column:
- NULL and NOT NULL
- FORMAT 'format string'
- TITLE
- NAMED
- DEFAULT NULL
- DEFAULT value
- 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(TIME WITH TIME ZONE) column:
- DEFAULT USER
- DEFAULT DATE
- DEFAULT TIME
- DEFAULT CURRENT_DATE
- DEFAULT CURRENT_TIME[(n)]
- DEFAULT CURRENT_TIMESTAMP[(n)]
- UPPERCASE or UC
- CASESPECIFIC or CS
- CHARACTER SET
- WITH DEFAULT