Table of Contents

Search

  1. Preface
  2. The Transformation Language
  3. Constants
  4. Operators
  5. Variables
  6. Dates
  7. Functions
  8. Creating Custom Functions
  9. Custom Function API Reference

Transformation Language Reference

Transformation Language Reference

Rules and Guidelines for Date Format Strings

Rules and Guidelines for Date Format Strings

Use the following rules and guidelines when you work with date format strings:
  • 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.
  • The format string must be enclosed within single quotation marks.
  • The
    PowerCenter Integration Service
    uses the default date time format specified in the session. Default is MM/DD/YYYY HH24:MI:SS.US. The format string is not case sensitive.