Use the following rules and guidelines when pushing functions to Netezza:
You can push SYSTIMESTAMP(‘SS’) to a Netezza database, but not SYSTIMESTAMP(‘MS’) or SYSTIMESTAMP(‘US’).
When you push TO_CHAR(DATE) or TO_DATE() to Netezza, dates with subsecond precision must be in the YYYY-MM-DD HH24:MI:SS.US format. If the format is different, the PowerCenter Integration Service does not push the function to Netezza.
