You can convert a character string to a DATE value with either the CAST statement or Teradata conversion syntax. Character-to-DATE Conversion with CAST Teradata Character-to-DATE Conversion Syntax Character-to-DATE Conversion Usage Notes Character-to-DATE Conversion Examples Related information Related information Example: ANSIDate Dateform Mode Data Type Formats and Format Phrases