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 vote329 views1 answer
Mysql récupérer le code création de vue
SQL
0 vote310 views1 answer
Mysql order by where condition sub query
SQL
0 vote320 views2 answers
How to tun mysql on ubunto
SQL
1 vote299 views1 answer
Sql only five first row
SQL
0 vote360 views1 answer
Traccar mysql
SQL
1 vote293 views1 answer
Sequence item 6 expected str instance bytes found mysql workbench
SQL
1 vote324 views1 answer
Right outer vs left outer join
SQL
1 vote325 views1 answer
Mysql select all and rename one
SQL
1 vote282 views1 answer
Psql show with user is logged in
SQL
0 vote330 views2 answers
Postgresql gset
SQL