Resolved: About Fixed point data type
what if we define it as DECIMAL(5,3) and try to insert the no. 12355.25865.....what will happen then?
3 answers ( 1 marked as helpful)
Hi Somil,
Why don't you try it then? Aren't you curious to discover the results? It's one of the joys of learning, right?
Best,
Carl
Yeah I tried, it was throwing an error
Hi Somil!
Thanks for reaching out.
That's right. It will throw an error because you specified only 3 digits after the decimal point and you provided the number with 5 digits.
Hope this helps.
Best,
Tsvetelin