How to use float in SQL for amount

Question

Dear I have a field called T_Amount data type is float e.g= T_Amount=11800 When i make formula in query (11800/24)*35.25=17331.25 but actually if i make in calculator (11800/24)*35.25=17331.24999 i want this full figure. Is i need to change the data type?

Manas Mohapatra · Answer

Use Decimal datatype instead of float. Because you need more accuracy and decimal is best siut fo that. However it is slower than Float/Double data type.

Rahul Chavan · Answer

Hi Bashit Please refer below Calculations and Query. Everything looks good.