Skip to content

Columns with float data type

MichelleTaylorRG edited this page Jun 19, 2019 · 1 revision

From http://blogs.lessthandot.com/index.php/DataMgmt/DBProgramming/do-not-use-the-float-data-type:

That may seem a little harsh, and it’s not always true. However, most of the time, the float data type should be avoided. Unfortunately, the float (and real) data types are approximate data types that can lead to significant rounding errors.

How to correct it: Examine the data you are using and identify the precision and scale required. Change the data type (or code) to use a decimal with the precision and scale you require.

Clone this wiki locally