Arithmetic overflow error converting numeric to data type numeric while saving decimal

Question

I'm trying to save decimal value in DB but getting this error.

The value I'm trying to save 0.00038711029163348665 or 1.00038711029163348665 or 2.00038711029163348665, and column in DB is Decimal(18,18) not sure what I'm doing wrong

You need to read the docs and understand precision and scale — Dale K
– Dale K, Commented Sep 18, 2019 at 1:35

Tim Biegeleisen · Accepted Answer · 2019-09-18 08:31:01Z

3

The precision DECIMAL(18,18) means 18 total units of precision, all 18 of which come after the decimal point. You need at least one unit of precision to the left of the decimal point to handle the whole number components of the input, so you should be using DECIMAL(19,18), or something similar.

See the demo to verify that DECIMAL(19,18) resolves your problem, at least for the data you showed us.

edited Sep 18, 2019 at 8:31

answered Sep 18, 2019 at 1:34

Tim Biegeleisen

526k32 gold badges323 silver badges399 bronze badges

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

Comments

Gordon Linoff · Accepted Answer · 2019-09-18 01:34:08Z

2

Decimal(18,18) has 18 digits to the right of the decimal place and none to the left, so 1.00038711029163348665 doesn't fit.

Use a larger type. Why not just use decimal(38, 18)?

answered Sep 18, 2019 at 1:34

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

Collectives™ on Stack Overflow

Arithmetic overflow error converting numeric to data type numeric while saving decimal

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related