2682463 - Functions utc_to_local and local_to_utc cause invalid output when the source column is used in multiple mappings in a single query

• After using the function utc_to_local or local_to_utc on a datetime column, subsequent mappings of that column are showing the wrong datetime
• i.e. The result of local_to_utc(<column_name>,<time-zone>) and Query.<column_name> are the same, and one should be different

SAP Data Services 4.x

When call a function on a column, you are permanently altaring the value of that column for the duration of the job.

To resolve this issue, you have three options:

1. Create multiple copies of the input column and use a seperate function call for each one.
2. Use utc_to_local after calling local_to_utc on the same column, and vice versa.
3. If you are using multiple mappings of the column but only using one function, put the function call on the very bottom of the schema out, which will call it last.

BODS, time, date, unexpected, wrong , KBA , EIM-DS-EXE , Job Execution , Problem