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;

Embed on website

To embed this project on your website, copy the following code and paste it into your website's HTML: