Converting SQL Server data types.

sismex01 at hebmex.com sismex01 at hebmex.com
Tue Mar 4 14:14:00 EST 2003


Hello yalls :-)

I've a problem.  When running some database queries and
formatting results, I found that some columns are type
"money", and these arrive as a tuple of integers,
as this:

    (0, 1364570710)

when it should in fact read as:

    136457.0710

So... how do I convert from type MONEY to type FLOAT,
inside python?  I wouldn't want to have to modify the
dbase side, but if there's no other way I'll do it
(rather than do 200+ reports by hand, again...)

:-)

Thanks!

-gustavo





More information about the Python-list mailing list