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 vote322 views1 answer
Show size of all tables postgres
SQL
0 vote342 views1 answer
Geopoint from json mysql function
SQL
34 votes391 views6 answers
Alter table add foreign key mysql
SQL
1 vote302 views3 answers
Remove unique key from a table
SQL
0 vote324 views1 answer
I wanted to select among the rows the highest value in mysql
SQL
1 vote301 views1 answer
Firebase bigquery cloud message
SQL
0 vote317 views1 answer
ORACLE SUBSTRING SYNTAX
SQL
1 vote343 views1 answer
Incompatible sql_mode=only_full_group_by
SQL
0 vote358 views2 answers
How to get max from each department in sql
SQL
0 vote346 views1 answer
Error code 1241 mysql
SQL