SAP Knowledge Base Article - Preview

2066574 - Cast/convert functions return an inconsistent result - SAP IQ

Symptom

Using round gets 3 result wrong from the select statement. 2.3 , 2.4 and 33.8 we got 2.29, 2.39 and 33.79. without round, got 2.3 and 33.8 wrong with 2.29 and 33.79.


Read more...

Environment

  • SAP IQ 12.7
  • SAP IQ 15.x
  • SAP IQ 16.0

Product

SAP IQ 16.0 ; SAP Sybase IQ 15.2 ; SAP Sybase IQ 15.4 ; Sybase IQ 12.7

Keywords

wrong result, round, approximate values. , KBA , BC-SYB-IQ , Sybase IQ , 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.