Click here to Skip to main content
14,695,085 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
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?

What I have tried:

i was using float for amount. when i was doing divide result is not accurate
Posted
Updated 13-Apr-16 10:23am
Comments
Richard MacCutchan 12-Apr-16 6:03am
   
Never use float for financial amounts. Use integer or decimal.

Try this query,

SELECT CAST((11800.00/24.00) as DECIMAL(20,5)) * 35.25
   
SELECT (CONVERT(DECIMAL,11800)/24)  * 35.25
   

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900