Parse float to int in postgresql
You would be better suited casting the columns that were text, to numeric, to integer, so that rounding is taken into consideration e.g.
SELECT '25.3'::numeric::integer AS num1, '25.5'::numeric::integer AS num2
which would return integers of 25 and 26 respectively.
If you were not concerned with the digits following the point, the floor(column_name::numeric)::integer
function or a substring, as mentioned, should be fine.
hcarrasko
I'm an engineer from Chile. I love programming Github Linkedin
Updated on December 29, 2020Comments
-
hcarrasko over 3 years
I've a set of data in a postgresql DB, where one of these columns store string data in float format, but now I need remove the decimal component of the string. How can I do this using an sql update statement in my BD console? Is that possible?
for example:
"25.3" -> "25"
If it does not possible how can I do this? Thanks in advance.