A point difference when calculating same values from SQL/Calculator and Javascript

Asked Jul 18 '19 at 12:57

Active Jul 18 '19 at 12:57

Viewed 21 times

Different Number resulting, When im performing below calculation at SQL side and Javascript side,

0.4583 * 3000

var i = 0.4583 * 3000
 
console.log(i)

Result from SQL : 1374.9000

Result from Calculator : 1374.9

Result from JS Console : 1374.8999999999999

Expected result : 1374.9000

asked Jul 18 '19 at 12:57

sison kk

1

SQL and your calculator use a different number representation than JavaScript (and most other programming languages). – Pointy Jul 18 '19 at 12:58
SO how can i get the same result in both SQL and JS console? @Pointy – sison kk Jul 18 '19 at 12:59
JavaScript uses binary floating point; a value like 9/10 (`.9`) cannot be represented exactly, just like 2/3 cannot be represented exactly in decimal floating point. – Pointy Jul 18 '19 at 13:02
thanks for the quick response – sison kk Jul 18 '19 at 13:04

0 Answers0