How can I count all decimal place up to the first zero
For example I have a column named x with an entry of numeric datatype value 1.955000000
I want to count the decimal places without the zeros. So here I want the query to make an output of 3 not 9 (with zeros)
Asked by DataLordDev
(63 rep)
Aug 12, 2019, 08:02 AM
Last activity: Sep 13, 2021, 06:50 PM
Last activity: Sep 13, 2021, 06:50 PM