Sample Header Ad - 728x90

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