Click here to Skip to main content
14,664,481 members
Rate this:
Please Sign up or sign in to vote.
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 9:23am
Comments
Richard MacCutchan 12-Apr-16 6:03am
   
Never use float for financial amounts. Use integer or decimal.

Rate this:
Please Sign up or sign in to vote.

Solution 1

Try this query,

SELECT CAST((11800.00/24.00) as DECIMAL(20,5)) * 35.25
   
Rate this:
Please Sign up or sign in to vote.

Solution 2

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, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100