round() function not rounding

Matt M.

Hi folks,

I have  a query like this I'm trying to execute with the nodejs driver:

SELECT

  ROUND(ACT_DOLLARS,2) AS "actualDollars"

FROM mytable

WHERE charge_no = 'charge123'

ORDER BY year;

When I execute the query in a database client, in this case SQL Developer, I get the following result:

actualDollars=36524.27

When I run it through the node driver I get the following:

actualDollars=36524.270000000004

Any ideas?

If it helps, the table is defined like this:

ACT_DOLLARS NUMBER

YEAR VARCHAR2(4 BYTE)

Many thanks!

-Matt

Christopher Jones-Oracle

See

https://github.com/oracle/node-oracledb/issues/68

http://stackoverflow.com/questions/1458633/how-to-deal-with-floating-point-number-precision-in-javascript