question about cx_Oracle .thanks
David Fraser
davidf at sjsoft.com
Fri Jun 25 02:41:22 EDT 2004
coolmenu wrote:
> Hi
> i hava a db ORACLE 10G,a table valid_card
> (card_no,varchar2(10),now_balance number (12,2))
>
> its'some record in table ('7188','42055.66')
>
> i use cx_Oracle to select now_balance from table
>
> curobj.execute("select loan_amount from valid_card where
> card_no='7181930166881974'");
> [<NumberVar object at 0x013A6920>]
>
>>>>tuple=curobj.fetchone()
>>>>tuple
>
> (42505.660000000003)
>
> why 42505.66---->42505.6600000000003???
> thanks
This is because of the conversion of the float to decimal. Float objects
have limited accuracy. I don't think it's much to do with cx_Oracle
David
More information about the Python-list
mailing list