<div>
Round() or Cast as type decimal, with two decimal places<br />
<br />

<pre><code id="code-20-41879387-1">DECLARE @money money
SET @money = 19.7562            
DECLARE @money money
SET @money = 19.7562            
SELECT  CAST(@money AS DECIMAL(18,2))
		, ROUND(@money, 2)</code></pre>
</div>


Round() or Cast as type decimal, with two decimal places



DECLARE @money money
SET @money = 19.7562            
DECLARE @money money
SET @money = 19.7562            
SELECT  CAST(@money AS DECIMAL(18,2))
		, ROUND(@money, 2)

<div>
<div class="content wysiwyg-content">
I'm using sql server 2008<br />
<br />
I have a money column in sql server.<br />
The data in the column has 4 decimal places.<br />
<br />
In my select query how to i display only 2 decimal places?
</div>
</div>


I'm using sql server 2008

I have a money column in sql server.
The data in the column has 4 decimal places.

In my select query how to i display only 2 decimal places?

t-sql money data type decimal places

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.