Convert a numeric column with number eg.(-1222222) to two float column with two decimal places eg (-12222.22)
0
votes
1
answer
451
views
I know there are different variations of this question asked.
But what I am trying to do is that, there is a table with a numeric column (12,0)
that has data looking like
Units
-----
-1222222
0
-19
21123021
What they really mean is this
Units
-----
-12222.22
0.00
-0.19
211230.21
With two decimal places in the last digits of each number.
I am struggling to convert these numbers to a two decimal place float column(Units)
Asked by masksoverflow
(137 rep)
Feb 20, 2020, 06:17 PM
Last activity: Feb 20, 2020, 06:43 PM
Last activity: Feb 20, 2020, 06:43 PM