Display preceisely 2 digits after decimal point in SQL Server

Posted by Rajnilari2015 under Sql Server category on | Points: 40 | Views : 116
Suppose we have a number like 123456.98072340

The output should look like 123456.98 i.e. precisely 2 digits after decimal.

The query is:

SELECT CAST(ROUND(123456.98072340, 2, 1) AS DECIMAL(18, 2))

Comments or Responses

Login to post response