Answers for "NUMBER(12,2) in sql"

SQL

0

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

Posted by: Guest on August-13-2021

Code answers related to "NUMBER(12,2) in sql"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Python

Javascript

Whatever

Shell/Bash

CSS

Html

PHP

SQL

Java

C#