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