SAP Knowledge Base Article - Preview

1943085 - ROUND function returns an incorrect results for the floating point data type -SAP IQ


  • When use the ROUND function, IQ table and SA table returns different values ​​for the floating-point data type.
  • For example, when a double type floating point type is set to "0.5", if you run from the SA table, ROUND function returns the correct value "1.0".
  • However, if you run the ROUND function from IQ table, IQ returns a value "0.0".



  • SAP IQ 15.2
  • SAP IQ 15.3
  • SAP IQ 15.4


SAP Sybase IQ 15.2 ; SAP Sybase IQ 15.4


double, CR710657, 710657 , KBA , BC-SYB-IQ , Sybase IQ , Bug Filed

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.