The format of the TO_DATE string must match the format string. If it does not, the
PowerCenter Integration Service
might return inaccurate values or skip the row. For example, if you pass the string ‘20200512’, representing May 12, 2020, to TO_DATE, you must include the format string YYYYMMDD. If you do not include a format string, the
PowerCenter Integration Service
expects the string in the date format specified
in the session.
Likewise, if you pass a string that does not match the format string, the
PowerCenter Integration Service
returns an error and skips the row. For example, if you pass the string 2020120 to TO_DATE and include the format string YYYYMMDD, the
PowerCenter Integration Service
returns an error and skips the row because the string does not match the format string.