You can convert an INTERVAL value to its canonical character string representation with either the CAST statement or Teradata conversion syntax.
INTERVAL-to-Character conversion is supported for CHAR and VARCHAR types only. The target type cannot be CLOB.