The character expression is trimmed of leading and trailing pad characters and handled as if it was a string literal in the declaration of a DATE literal.
Character-to-DATE conversion is supported for CHAR and VARCHAR types only. The source character type cannot be CLOB.
If the string can be converted to a valid DATE, then it is. Otherwise, an error is returned.