ANSI Compliance
This statement is a Teradata extension to the ANSI SQL:2011 standard.
INTERVAL-to-Fixed CHARACTER Conversion
When the target data type is CHAR(n), then n must be equal to or greater than the length of the canonical form of the value as represented by a character string literal.
If n is greater than that length, trailing pad characters are added to pad the canonical representation.
If n is too small, then a string truncation error is returned.
INTERVAL-to-VARCHAR Conversion
When the target data type is VARCHAR(n), then n must be equal to or greater than the length of the canonical form of the value as represented by a varying character string literal.
If n is too small, then a string truncation error is returned.
Syntax
interval_expression ( [ data_attribute [,...] ] character_data_type [, { data_attribute | CHARACTER SET server_character_set } [,...] ] )
Syntax Elements
- interval_expression
An INTERVAL expression to be converted.
- data_attribute
- One of the following data attributes:
- FORMAT
- NAMED
- TITLE
- character_data_type
The data type to which the expression is to be converted.
- server_character_set
The server character set to use for the conversion. If the CHARACTER SET clause is omitted, the user default server character set is used.