Monday, February 22, 2010

Programmer - Is MS SQL 'MONEY' data type a decimal floating point or binary floating point?

Programmer Question

I couldn't find anything that rejects or confirms whether MS SQL 'MONEY' data type is a decimal floating point or binary floating point.



In the description it says that MONEY type range is from -2^63 to 2^63 - 1 so this kind of implies that it should be a binary floating point.



But on this page it lists MONEY as "exact" numeric. Which kind of suggests that MONEY might be a decimal floating point (otherwise how is it exact? or what is the definition of exact?)



Then if MONEY is a decimal floating point, then what is the difference between MONEY and DECIMAL(19,4) ?

No comments:

Post a Comment

LinkWithin

Related Posts with Thumbnails