INF: Translating DBMONEY Datatype into Actual Dollar Amount

ID: Q67871

The information in this article applies to:

Microsoft SQL Server versions 4.2x, 6.0, 6.5, 7.0

SUMMARY

The following information explains how to translate the DBMONEY datatype, which is a structure containing 2 long INTs, to the dollar amount it represents.

MORE INFORMATION

The internal storage of the DBMONEY datatype keeps track of 1/100 of a cent, which equates to .0001 of a dollar. Therefore, you can have precision to four decimal places.

The high word unit is (2^32); this value is 4294967296.

If you enter 429496.7296 in a money field with ISQL and examine the low and high words after extracting the structure with a DB-Library program, you will see high=1, and low=0; therefore, the formula would be as follows:

round(2, ((high*4294967296)+low) / 10000)

This would return $429,496.73.

Additional query words: DB-Library DB-Lib dblib

Keywords : kbprg SSrvGen SSrvServer SSrvWinNT
Version : winnt:4.2x,6.0,6.5,7.0
Platform : winnt
Issue type :