Parse float to int in postgresql

Question

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.

Answer 1

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.