select float('92233464567.33') returns

92,233,466,000

I am expected result will be around 92,233,464,567.xx

therefore, float data type should be avoided.

Use double or decimal works as expected.

But I see float data type is widely used assuming most numeric values are < 1 billion.