SQL Server extract only the number after the decimal point
One of my blog readers asked me "Is there a way to extract only the number after the decimal point?". For example, in decimal number 45.90, 45 is the precision and 90 is the scale value. There are several methods to get this done Let us create this d...
soykanozcelik.hashnode.dev1 min read
Rajanand Ilangovan
Data Engineer
Hi Soykan OZCELIK,
Just a note on precision for your reference. The precision is the number of digits in the number and scale is the number of digits after the decimal. As per the example 45.90 has precision of 4 (as there are 4 digits in 45.90) and scale of 2 (i.e., 90).
docs.microsoft.com/en-us/sql/t-sql/data-types/pre…
Thanks, Rajanand