SAP Knowledge Base Article - Preview

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

Symptom

  • 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


Read more...

Environment

SAP Data Services 4.x

Product

SAP BusinessObjects Dashboards 4.0

Keywords

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

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.