#sqldecimal — Public Fediverse posts
Live and recent posts from across the Fediverse tagged #sqldecimal, aggregated by home.social.
-
Why does this SQL FLOAT lose cents in billing?
Why does this SQL FLOAT lose cents in billing. The SQL code uses FLOAT for money. In SQL floating point cannot represent decimals exactly. In SQL finance 0.1 + 0.2 is not 0.3 and money disappears.
#whatswrongwiththissqlquery #sqlbug #sqlproductionbug #sqldebugging #sqldatabase #sqlcodereview #sqlperformance #sqlreliability #sqlanalytics #sqldataintegrity #sqlengineering #sqlfloat #sqldecimal #sqlmone...
-
Why does this SQL FLOAT lose cents in billing?
Why does this SQL FLOAT lose cents in billing. The SQL code uses FLOAT for money. In SQL floating point cannot represent decimals exactly. In SQL finance 0.1 + 0.2 is not 0.3 and money disappears.
#whatswrongwiththissqlquery #sqlbug #sqlproductionbug #sqldebugging #sqldatabase #sqlcodereview #sqlperformance #sqlreliability #sqlanalytics #sqldataintegrity #sqlengineering #sqlfloat #sqldecimal #sqlmone...