COM and currency conversion

John notehead2 at hotmail.com
Sun May 6 18:47:27 EDT 2001


I've run into another issue with using ADO/SQL Server with Python. It has to
do with how money fields come across in Python. Python converts the money
field into a 2 value tuple. Anyone know the way to get a meaningful dollar
about back out? Here are some examples of dollar amounts and their
representation in Python:

$1,234,567.01 == (2, -539231788)
$1,000,000.00 == (2, 1410065408)
$2,000,000.00 == (4, -1474836480)

-John






More information about the Python-list mailing list