src_col1 = 124.000000
I want to change this to 124 (without the decimal or zeros).
According to the documentation the following line of code should do the trick:c/p from docs:
tostring(value, format string)
Definition: Converts a value, such as number, time, or date, to its string representation.
%i
Represents the value to be converted into a signed decimal integer, such as "123."
tostring(src_col1,'%i')
It does not. The result is 0