SAP Knowledge Base Article - Preview

2854085 - When using to_date() function, not all rows are output - Data Services

Symptom

  • When using the to_date() function to convert a text string to a date, not all of the rows are processed
  • Records are missing when using to_date() function
  • Optimized SQL shows the to_date() function is being pushed down to the database


Read more...

Environment

  • SAP Data Services
  • Microsoft SQL Server

Product

SAP Data Services 4.2

Keywords

BODS, to_date(), pushdown, push down, conversion, data type, datatype , KBA , EIM-DS-EXE , Job Execution , EIM-DS , Data Services , 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.