Use CAST syntax or Teradata explicit conversion syntax to convert an INTERVAL type to its canonical character string representation.
INTERVAL-to-Character conversion is supported for CHAR and VARCHAR types only. The target type cannot be CLOB.
An INTERVAL expression to be converted.
The data type to which the expression is to be converted.
The server character set to use for the conversion. If the CHARACTER SET clause is omitted, the user default server character set is used.
- One of the following data attributes: