SQL Display two digits after decimal point
Posted by SceDev
Last Updated: February 08, 2024

The scripts below demonstrate how to display two digits after decimal point in SQL.


Using CAST:

SELECT CAST(344.3423 as DECIMAL(10,2))

 

Using CONVERT:

SELECT CONVERT(DECIMAL(10, 2), 344.3423)