CREATE TABLE demo (
valor_float FLOAT,
valor_decimal DECIMAL(20,10)
);
INSERT INTO demo VALUES (0.1 + 0.2, 0.1 + 0.2);
SELECT
valor_float,
CAST(valor_float AS DECIMAL(20,18)) AS valor_float_extendido,
-- CAST se usa para forzar el tipo de dato introducido a FLOAT
valor_decimal
FROM demo;
To embed this project on your website, copy the following code and paste it into your website's HTML: