Microsoft KB Archive/67871

= INF: Translating DBMONEY Datatype into Actual Dollar Amount =

Article ID: 67871

Article Last Modified on 2/14/2005

-

APPLIES TO


 * Microsoft SQL Server 4.21a Standard Edition
 * Microsoft SQL Server 6.0 Standard Edition
 * Microsoft SQL Server 6.5 Standard Edition
 * Microsoft SQL Server 7.0 Standard Edition

-



This article was previously published under Q67871



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: kbprogramming KB67871

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.