Convert decimal values in SQL Server

Venkatesan Jayakantham
14y
4.7k
0
0

Blog

Convert a integer value with multiple decimals to fixed number of decimals(2 decimals):
Consider a scenario, am having a decimal data and I need to restrict the decimal values. In this case, we need to use convert operator.

create table aa(id decimal(10,5))
insert into aa values(1.90955)
select convert(decimal(10,2),id) from aa

Cheers,
Venkatesan Prabu .J
http://venkattechnicalblog.blogspot.com/