Implicit Character-to-DATE Conversion - Advanced SQL Engine - Teradata Database

If the string does not represent a valid date, an error is reported.

In record or indicator mode, when the DateForm mode of the session is set to ANSIDate, the string must use the ANSI DATE format.