Period-to-Character Conversion | VantageCloud Lake - Period-to-Character Conversion - Teradata Vantage

You can convert a period value to its canonical character string representation with either the CAST statement or Teradata conversion syntax.

Period-to-character conversion is supported for CHAR and VARCHAR types only. The target type cannot be CLOB.

• Period-to-Character Conversion with CAST
• Teradata Period-to-Character Conversion Syntax
• Period-to-Character Conversion Usage Notes
• Example: Converting a PERIOD Data Type to Its Canonical Character String Representation