Is super-accuracy matters?

[johnb]

(10-24-2023 01:33 PM)KeithB Wrote:  Which is why Microsoft introduced the "decimal" type ...
https://learn.microsoft.com/en-us/dotnet...ew=net-7.0

Also, in SQL Server / Transact SQL, the DECIMAL or NUMERIC type, which is very similar.

I've always specified things like DECIMAL(19) for small monetary values and DECIMAL(29) for large ones, since that can handle values as large as a country's GNP, and can handle conversions between world currencies to an accuracy equivalent to any denomination.

I've always wondered why T-SQL's "MONEY" and "SMALLMONEY" types have only two guard digits and not three. So I've been wary to use them. Am I mistaken -- aren't there cases where the lack of a third guard digit can cause an error to show up in the result?

[Yes, this is now "Not [even] remotely HP Calculators" - LOL.]