You can convert a DATE value to a character string with either the CAST statement or Teradata conversion syntax.