why is it (10,2) in particular ? – Q&A Hub | 365 Data Science (2024)

FAQs

Why is it (10,2) in particular ? – Q&A Hub | 365 Data Science? ›

DECIMAL(10,2) means you can have a decimal number with a maximal total precision of 10 digits.

- It is defined as `numeric(p, s)`, where `p` is the precision (total number of digits), and `s` is the scale (number of digits to the right of the decimal point). - Example: `numeric(10, 2)` can store numbers with up to 10 digits, 2 of which can be to the right of the decimal point.

You add the WHERE 1=2 clause to the SELECT INTO query so that you can make a copy of the table's structure without any actual data.

main = do. forM_ [1.. 10] print.

Weight Decimal (5,2) means the total number of digits cannot exceed 5 and 2 digits can be placed to the right of the decimal. However, the value 1000.45 in the second line of code above exceeds the specified range of (5, 2) since it means 6 digits in total and throws an overflow error.

When it says NUMBER(8,2), it means that there will be 8 digits, and that the number should be rounded to the nearest hundredth. Which means that there will be 6 digits before, and 2 digits after the decimal point.

As you see, DECIMAL(10,4) defines a number containing a total of ten digits, with four to the right of the decimal place. It follows there are six to the left.

Assuming you mean that the database type is decimal(6, 2), then this means that your column is set up to store 6 places (scale), with 2 to the right of the decimal (precision). You should treat this as a decimal CLR type. A sample would be 1234.56 .