14,733,037 members
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.

## Solution 2

`SELECT (CONVERT(DECIMAL,11800)/24)  * 35.25`

## Solution 1

Try this query,

`SELECT CAST((11800.00/24.00) as DECIMAL(20,5)) * 35.25`

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

Top Experts
Last 24hrsThis month
 Richard Deeming 115 OriginalGriff 85 Maciej Los 65 CHill60 60 CPallini 58
 OriginalGriff 2,815 Richard MacCutchan 1,280 CPallini 1,088 thatraja 665 Maciej Los 637

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