INF: Translating DBMONEY Datatype into Actual Dollar Amount

ID: Q67871

The information in this article applies to:

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 C 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           : 4.2 | 4.2
Platform          : OS/2 WINDOWS 
Issue type        :

Last Reviewed: March 10, 1999