Very Computer

SQL Server 2000, no service pack.

SELECT ROUND (CAST( 24.399999999999999 as float), 2)
-----------------------------------------------------
24.399999999999999

SELECT ROUND (CAST( 24.399999999999999 as real), 2)
-----------------------------------------------------
24.399999999999999

SELECT ROUND (CAST( 24.399999999999999 as money), 2)
---------------------
24.4000

SELECT ROUND (CAST( 24.399999999999999 as decimal(8,4)), 2)
----------
24.4000

Do you observe the same? Am I missing something?

real and float data types are known as 'approximate' ones, therefore, the
inaccuracy is not unsuprising.

--
Tony Rogerson SQL Server MVP
Torver Computer Consultants Ltd
www.sql-server.co.uk [UK SQL Server User Group - FAQ, SQL Tutorials etc...]

Quote:> SQL Server 2000, no service pack.

> SELECT ROUND (CAST( 24.399999999999999 as float), 2)
> -----------------------------------------------------
> 24.399999999999999

> SELECT ROUND (CAST( 24.399999999999999 as real), 2)
> -----------------------------------------------------
> 24.399999999999999

> SELECT ROUND (CAST( 24.399999999999999 as money), 2)
> ---------------------
> 24.4000

> SELECT ROUND (CAST( 24.399999999999999 as decimal(8,4)), 2)
> ----------
> 24.4000

> Do you observe the same? Am I missing something?

<<inaccuracy is not unsuprising.>>

So many negatives...

:)

--
Tony Rogerson SQL Server MVP
Torver Computer Consultants Ltd
www.sql-server.co.uk [UK SQL Server User Group - FAQ, SQL Tutorials etc...]

This is a fairly common "problem". Rounding 2.39999999. to 2 dp. should
gives 2.4 when using infinite precission math, however 2.4 cannot be
represented exactly in BASE2 (binary), the closest possible approximation is
2.3999999999

This is because 1/10th is a repeating fraction when represented in BASE2
(just like 1/3 is a repeating fraction when represented as BASE10).

Quote:> SQL Server 2000, no service pack.

> SELECT ROUND (CAST( 24.399999999999999 as float), 2)
> -----------------------------------------------------
> 24.399999999999999

> SELECT ROUND (CAST( 24.399999999999999 as real), 2)
> -----------------------------------------------------
> 24.399999999999999

> SELECT ROUND (CAST( 24.399999999999999 as money), 2)
> ---------------------
> 24.4000

> SELECT ROUND (CAST( 24.399999999999999 as decimal(8,4)), 2)
> ----------
> 24.4000

> Do you observe the same? Am I missing something?