You can convert a character string to an INTERVAL value with either the CAST statement or Teradata conversion syntax. Character-to-INTERVAL Conversion with CAST Teradata Character-to-INTERVAL Conversion Syntax Character-to-INTERVAL Conversion Usage Notes Character-to-INTERVAL Conversion Examples