cancel
Showing results for 
Search instead for 
Did you mean: 

Why ​precision/scale for 0.0000001234 is 4/10 and for 1234000000 is 4/6?

valerjans
Explorer
0 Kudos
125

In SAP HANA SQL Reference Guide for SAP HANA Platform

(SQL Reference - Data Types - Numeric Data Types)

is written:
0.0000001234 (1234E-10) has precision 4 and scale 10.
1.0000001234 (10000001234E-10) has precision 11 and scale 10.
The value 1234000000 (1234E6) has precision 4 and scale 6.

So, if precision/scale for 0.0000001234 is 4/10 and for 1234000000 is 4/6, then what precision/scale has 0.001234?

Accepted Solutions (0)

Answers (0)