I am doing a conversion of a numeric value 999999999999999 to string using the STR() function as STR(999999999999999,15). However, it returns just * signs. When the precision is changed to 16 from 15 it works. Also when the value goes <=999999999999997 it works. Using the CAST() instead of STR() also does the job.
Why is this not working for STR(999999999999999,15)?
STR() returns Arithmetic overflow
in SQL
Posted
Hi,
I am doing a conversion of a numeric value 999999999999999 to string using the STR() function as STR(999999999999999,15). However, it returns just * signs. When the precision is changed to 16 from 15 it works. Also when the value goes <=999999999999997 it works. Using the CAST() instead of STR() also does the job.
Why is this not working for STR(999999999999999,15)?
Thanks