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 vote180 views1 answer
Sqlite3_open_v2
SQL
0 vote169 views1 answer
Search In the Database using Text
SQL
0 vote222 views1 answer
Drop domain postgresql
SQL
0 vote203 views1 answer
Mysql join only one column
SQL
0 vote188 views1 answer
Drop column from table if exist on live server mysql
SQL
4 votes195 views1 answer
For loop postgresql
SQL
0 vote174 views4 answers
Mysql desactivar trigger
SQL
1 vote221 views1 answer
Ora-01109 database not open in oracle 19c
SQL
0 vote191 views1 answer
Hotw to alter lengh character vayng postgres
SQL
0 vote137 views1 answer
Big query add table rows to another table
SQL