The floating-point tag has no wiki summary.
0
votes
0answers
40 views
Mysql float(13,3) not taking 10 digits [duplicate]
I have a total amount field of type float(13,3). When I tried to insert 123456789 to that field, the data changed to 123456792.000. I am not getting any truncate error. But data is changing while ...
1
vote
3answers
103 views
How to enforce full integer (no floating point)?
Why is the following allowed
INSERT INTO c VALUES (123.2,'abcdefghijklmnopqrstuvwxyzabcdef', 'abcdefghijklmnop');
When table contains
CustomerID NUMBER(3,0) -- That's the 123.2 entry
In ...
1
vote
1answer
78 views
How to prepare a date and double for a mysql replace statement?
I have a MySql table with three columns:
CU VARCHAR(3)
DA DATETIME
VA DOUBLE
I need to execute several REPLACE into mytable (CU, DA, VA) values("ABC", mydate, myval) statements from Java. mydate is ...
3
votes
2answers
585 views
MySQL conversion from float (10,2) to fixed(10,2)
I have a database that contains financial data stored as floats. Naturally, this can present a real issue at random times (eg, when there is an exact value that cannot be approximated closely enough ...
