Subject | cast question |
---|---|
Author | Alberto Pesce |
Post date | 2005-05-11T07:19:34Z |
Hi all,
Why if I submit value like 323,3 to a store procedure I obtain in table the value 323,29998
like:
PROCEDURE NEW_PROC (float input, .....)
begin
....
INSERT INTO TABLE PROVA (enter,.....) VALUE (input,....)
/* note in table prova field 'enter' is a numeric (15,5) */
....
end
I don't understand why?
Thanks to all
Alberto
____________________________________________________________
Navighi a 4 MEGA e i primi 3 mesi sono GRATIS.
Scegli Libero Adsl Flat senza limiti su http://www.libero.it
Why if I submit value like 323,3 to a store procedure I obtain in table the value 323,29998
like:
PROCEDURE NEW_PROC (float input, .....)
begin
....
INSERT INTO TABLE PROVA (enter,.....) VALUE (input,....)
/* note in table prova field 'enter' is a numeric (15,5) */
....
end
I don't understand why?
Thanks to all
Alberto
____________________________________________________________
Navighi a 4 MEGA e i primi 3 mesi sono GRATIS.
Scegli Libero Adsl Flat senza limiti su http://www.libero.it