- 4728 Views
- 1 replies
- 1 kudos
Never use the float data type
select float('92233464567.33') returns 92,233,466,000I am expected result will be around 92,233,464,567.xxtherefore, float data type should be avoided.Use double or decimal works as expected. But I see float data type is widely used assuming most num...
- 4728 Views
- 1 replies
- 1 kudos
- 1 kudos
Float is Approximate-number data type, which means that not all values in the data type range can be represented exactly.Decimal/Numeric is Fixed-Precision data type, which means that all the values in the data type range can be represented exactly w...
- 1 kudos
- 3070 Views
- 1 replies
- 2 kudos
Resolved! SQL cast operator not working properly
please have a look at the attached screenshotThree strings converted to float, each resulting in the same number. 22015683.000000000000000000 => 2201568422015684.000000000000000000 => 2201568422015685.000000000000000000 => 22015684
- 3070 Views
- 1 replies
- 2 kudos
- 2 kudos
Hi @Maciej G​ ,I guess, this has something to do with the data type FLOAT and its precision.Floats are only an approximation with a given precision. Either you should consider using date type DOUBLE (double precision compared to FLOAT) - or, if you ...
- 2 kudos