Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

It's an issue with floating point accuracy usually...

2 point decimals can usually be accurate but given enough operations, you can sometimes get a weird floating error and rounding / clamping is discouraged in banking.



He's talking about fixed point, not floating point. The decimal type in SQL is an exact, fixed point numeric type. It can avoid loss of precision, like integer, but without the scale conversion step.




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: