Arithmetic overflow error converting float to data type numeric in SQL Server

Last Reply 11 days ago By iammann

Posted 12 days ago

93060000.000000 i want to update this value in my table where datatype of column is decimal(18,13)

93060000.000000 is float type

i am getting this error

Arithmetic overflow error converting float to data type numeric.

Posted 12 days ago Modified on 12 days ago

Hi iammann,

Try below query.

SQL

DECLARE @Data NUMERIC(18,6)
SET @Data = 93060000.000000
SELECT @Data AS Data

Output

93060000.000000


Posted 11 days ago

THanks @pandeyism but i have resolved it by myself.

 

I have just changed column datatype capacity 18,13 to 25,13