How to correct Arithmetic overflow error converting nvarchar to numeric for sql datatype numeric(9, 4)? [closed]

Question

Closed. This question needs to be more focused. It is not currently accepting answers.

Want to improve this question? Guide the asker to update the question so it focuses on a single, specific problem. Narrowing the question will help others answer the question concisely. You may edit the question if you feel you can improve it yourself. If edited, the question will be reviewed and might be reopened.

Closed 5 years ago.

Improve this question

I have the value as 2800320 which I need to insert to table for numeric(9, 4) datatype. In the code I have given as float.Parse(record.Substring(i, 8)).When I insert to sql arithmetic overflow error occurs. Pls tell how to correct this?

Is that a date, with a typo? Just curious with today being 28-03-20 and all.. — Caius Jard
– Caius Jard, Commented Mar 28, 2020 at 5:55
Can you share the code which inserts the data in table along with sample values? Which type of database it is? Ms SQL or my SQL? — Chetan
– Chetan, Commented Mar 28, 2020 at 5:58
Numeric(9,4) can not store 7 digit number coz it can accommodate only number with 5 digit before decimal point and 4 digits after decimal point. stackoverflow.com/questions/60897745/… — Chetan
– Chetan, Commented Mar 28, 2020 at 6:04

Caius Jard · Accepted Answer · 2020-03-28 05:58:59Z

1

NUMERIC(9,4) means "a number with 9 digits in total, 4 of which are after a decimal point" meaning you have 5 digits left over to store your 7 digit number 2800320

Clearly, this isn't going to work. Pick a bigger numeric, or divide your number by 100 or more so it will fit

answered Mar 28, 2020 at 5:58

Caius Jard

75k6 gold badges61 silver badges95 bronze badges

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

Collectives™ on Stack Overflow

How to correct Arithmetic overflow error converting nvarchar to numeric for sql datatype numeric(9, 4)? [closed]

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related