Best datatype to use for large monetary values ?? 
Author Message
 Best datatype to use for large monetary values ??

Any advice on the best datatype to use for large monetary values?

Should I use money fields, float fields, or numeric fields? My best
guess is numeric(28), for highest precision. But is it necessary to have
that many significant digits if the values are only in the billions? And
should I be specifying the number of digits after the decimal point as
well?

Also, what happens if you multiply, say numeric(10) and numeric(28)?
Does the result lose precision, or is the numeric(10) field converted to
numeric(28) internally?

Thanks for any help.

-- Charlie



Wed, 08 Dec 1999 03:00:00 GMT
 Best datatype to use for large monetary values ??

Money type is best - its well tried and tested.

Floats dont do arithmetic properly - its ok for designing roads, but
accountants like their pence to add up exactly.

Numerics are new to sql server - so its reasonable to expect some bugs.

Quote:

> Any advice on the best datatype to use for large monetary values?

> -- Charlie

--
Peter Collard
Senior DBA
Lehman Brothers, London



Mon, 13 Dec 1999 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Best datatype to use for large monetary values ??

2. bulk insert - incorrect monetary value

3. Keeping my .00 on Monetary values

4. Export Monetary values to Fixed Width

5. Float data type for monetary values

6. Best way to randomly access a large data file without using a database

7. Using Select to retrieve values of text datatypes

8. Large-DB tricks (was Re: Best DB for large # of records)

9. Is there a driver which will convert oracle datatype into sybase datatype ...when using with jdbc

10. SP_Configure truncates the values for min and max for large values

11. Datatypes for large quantities of text?

12. creating a large datatype (over 8000 characters)


 
Powered by phpBB® Forum Software