bind invalid when execute oracle sql statement.

[wqhflp at gmail.com]

Hi, I want to insert data into a table
SQL> desc jijin
 Name                                      Null?    Type
 ----------------------------------------- -------- -------------
 ID                                        NOT NULL  NUMBER(6)
 T_TIME                                NOT NULL  DATE
 NET_VALUE                                          NUMBER(5,4)
 TOTAL_VALUE                                      NUMBER(5,4)
 INCREASE                                            NUMBER(5,4)

The code I used is
       sql="insert into jijin values
(:id,to_date(:date,'yyyymmdd'),:net_value,:total_value)"
       day=int(date)

bindVars={'id':int(id),'date':int(day),'net_value':float(net),'total_value':float(total)}
       cur.execute(sql,bindVars)
       conn.commit()

the net ,total are in format of a string, a type of string, so we must
convert it into a number. But the problem is if we use float to convert
a string like '0.1' will be translated into 0.10000000000000001, which
is invalid for oracle type NUMBER(5,4).

How to resolve the problem?