Loading

How to use float in SQL for amount

Basit Khan

10y872

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?

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Manas Mohapatra10y ago
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.
0
Rahul Chavan10y ago
Hi Bashit,

Please refer below Calculations and Query. Everything looks good.

0