如何将小数转换为在MySQL中漂浮

Question

SELECT
    llac.name,
    l.Rate,
    ROUND(llac.loan__Interest_Rate__c, 2) 
FROM cl_import.loan__Loan_Account__c llac 
JOIN decision.loan l
    ON llac.id=l.sf_loan_id
WHERE
    (l.Rate) != llac.loan__Interest_Rate__c;

llac.loan __interest_rate__c是小数点，我想将其转换为float。

Answer 1

将您的mysql版本升级到8.0.17并使用铸件(列作为浮子(

参考：https://dev.mysql.com/doc/refman/8.0/en/cast-functions.html