Converting to 2 decimal places in sql query. linkcube1 asked on 4/26/2011. Microsoft SQL Server C# Microsoft SQL Server 2008. 20 Comments 3 Solutions 2092 Views Last Modified: 8/13/2012. In the following code below I want to take 80% of the price for each item and return a total amount. It does this fine but doesn't round to 2 decimal places I ...
Nov 07, 2018 · All my results have two decimal places even when the original value was an integer. The new built in function comes with two names, DECFLOAT_FORMAT and TO_NUMBER, and they both do the same things. If I add them to the previous SQL statement: