Answers for "sql decimal rount 4"

SQL
5

sql decimal(18 0)

-- DECIMAL(p,s)     p: number of digits (lkeft+right)  s: number of digits (right)
-- NUMERIC and DECIMAL are synonyms
CREATE TABLE test.sql_decimal (
    dec_col DECIMAL (4, 2)		-- Max total 4 digits, including 2 after decimal
);
INSERT INTO test.sql_decimal (dec_col) VALUES (10.05);		-- OK 4 digits
INSERT INTO test.sql_decimal (dec_col) VALUES (21.0425);	-- KO
Posted by: Guest on July-08-2021

Code answers related to "SQL"

Browse Popular Code Answers by Language