Number(10 2) in sql means

-- Precision of 10 and a scale of 2
SELECT CONVERT(DECIMAL(10, 2), col_name)

SELECT CONVERT(DECIMAL(10, 2), 2.999999)			-- 3.00
SELECT CONVERT(DECIMAL(10, 2), 12352.334)			-- 12352.33
SELECT CONVERT(DECIMAL(10, 2), 12564258524132.336)	-- Error: data truncation

Similar codes

0 vote151 views1 answer
Carbon mysql d m y to y-m-d
SQL
0 vote134 views1 answer
Mysql url
SQL
0 vote175 views1 answer
How to get column name in db from an sqlalchemy attribute model
SQL
1 vote154 views1 answer
How to delay stored procedure execution in sql server
SQL
3 votes137 views4 answers
Postgresql change timezone on timestamp without timezone
SQL
0 vote191 views3 answers
How to find all role in mysql
SQL
6 votes1.2K views1 answer
Sql select second max
SQL
0 vote132 views1 answer
Get foreign table names mysql
SQL
11 votes136 views2 answers
Insert current date sql
SQL
0 vote142 views1 answer
Sql stored procedure update if parameter is not null
SQL