Converting SQL Server data types.

sismex01 at hebmex.com sismex01 at hebmex.com
Tue Mar 4 21:15:23 CET 2003


> From: Gerhard Häring [mailto:gerhard.haering at gmx.de]
> Sent: Tuesday, March 04, 2003 2:16 PM
> 
> sismex01 at hebmex.com wrote:
> > 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)
> 
> Strange. Which database module is this that you're using?
> 
> > 
> > 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...)
> 
> If t is the tuple, t[1] * 10000.0 will work for this 
> particular sample 
> tuple.
> 
> -- Gerhard

argh... another victim of not seeing the trees for the
leaves... :-P

I'm accessing the database directly vía win32com.client.Dispatch
using ADODB.Connection objects.

Hmmm... it seems that I need to check my results better...
and get eyeglasses, maybe. :-)

Thanks Gerhard.

-gustavo





More information about the Python-list mailing list