To push the TRUNC(DATE) function to the PostgreSQL database. you must define the date and format arguments.

If you define only a string argument for the TO_DATE() and TO_CHAR() functions and omit the format argument, the PowerCenter Integration Service returns a string based on the default date format

MM/DD/YYYY HH24:MI:SS

specified in the session property.

When you push the SYSTIMESTAMP() function to a PostgreSQL database, do not specify the format argument. If you specify the format for SYSTIMESTAMP, the database ignores the format and returns the complete time stamp.

When you push the TO_BIGINT and TO_INTEGER functions to the PostgreSQL database, the PowerCenter Integration Service ignores the flag arguments.

When you push the IN() function to the PostgreSQL database, the PowerCenter Integration Service ignores the CaseFlag argument.

When you use the NS format string to set the nanoseconds for the ADD_TO_DATE() function, the PowerCenter Integration Service does not push the ADD_TO_DATE() function to PostgreSQL.

The PowerCenter Integration Service cannot push TO_CHAR() and TO_DATE() functions to PostgreSQL if you use the NS, JQW, SSSSS, and RR formats.

You can use formats such as D, HH24, MI, MM, MS, SS, US, and YYYY when you push the TRUNC(DATE) function to the PostgreSQL database.