SAP Knowledge Base Article - Preview

2084866 - date_diff() produces a negative value and in previous versions it only returned positive integers - Data Services


  • date_diff produces a negative value (i.e. date_diff('2012-12-13 00:00:00', '2012-12-12 00:00:00', 'D') = -1). This is contrary to documentation of date_diff functionality and breaks existing code in the migration from 4.1 to 4.2 SP3
  • date_diff documentation states:  "This function is equivalent to interval_to_char(date1 - date2, 'fmt_str'), except if date1 is smaller than date2, the date_diff function returns a positive value"



SAP Data Services 4.2 SP2 and later


SAP Data Services 4.2


KBA , EIM-DS-EXE , Job Execution , EIM-DS , Data Services , How To

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.