Arithmetic overflow error converting numeric to data type numeric

Question

i am having hard time determining the length of a Decimal data type. The data i have in column is like 0.08,1.2,12.35,121.36. Now if i go for (2,2) it throws an error : Arithmetic overflow error converting numeric to data type numeric. Just wondering should it be (6,2)? and if yes can anybody tell me Why 6 and 2?

Mike Sherrill 'Cat Recall' · Accepted Answer · 2011-05-25 13:57:09Z

3

In syntax like

NUMERIC(precision, scale)

precision is the total number of digits (count digits on both sides of the decimal point), and scale is the number of digits to the right of the decimal point.

answered May 25, 2011 at 13:57

Mike Sherrill 'Cat Recall'

96.6k20 gold badges134 silver badges195 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

RB. Over a year ago

@Programmer, so in your example, you would need Numeric(5,2) to accommodate your longest number 121.36, which has 5 digits, and 2 digits to the right of the decimal point.

Mike Sherrill 'Cat Recall' Over a year ago

@RB: At the very least. But the OP also needs to think about what to do with the result of expressions like 3.33 * 5.12 (17.0496).

CristiC · Accepted Answer · 2011-05-25 14:00:37Z

0

From your examples, should be NUMERIC(5,2) - meaning five numbers in total and 2 after the decimal point.

answered May 25, 2011 at 14:00

CristiC

22.7k13 gold badges62 silver badges89 bronze badges

Collectives™ on Stack Overflow

Arithmetic overflow error converting numeric to data type numeric

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related