Hello everyone,
Sourcing my financial data via JSON, I need to convert it into a number format before feeding it into a SQL Server row.
Would anybody know the best formula to convert a string into a number?
When using to_f, I get the following message.
Exception: SQL Statement error: TinyTds::Error: Arithmetic overflow error converting numeric to data type numeric.
However, the data is limited to decimals from 0.01 to 99.99.
Send us a ticket, we will try our best to assist you with your problem
Gabriel Burgener
Exception: SQL Statement error: TinyTds::Error: Arithmetic overflow error converting numeric to data type numeric
Hello everyone,
Sourcing my financial data via JSON, I need to convert it into a number format before feeding it into a SQL Server row.
Would anybody know the best formula to convert a string into a number?
When using to_f, I get the following message.
Exception: SQL Statement error: TinyTds::Error: Arithmetic overflow error converting numeric to data type numeric.
However, the data is limited to decimals from 0.01 to 99.99.