Answers for "float datatype column to int in postgre sql"

postgresql float data type

ALTER TABLE tableName 
ADD COLUMN columnName float(4);

Posted by: Guest on November-16-2021

postgres float to int

SELECT CAST(float_to_convert AS INTEGER) FROM your_table;
-- Or
SELECT float_to_convert::integer FROM your_table;

Posted by: Guest on August-26-2021

Code answers related to "float datatype column to int in postgre sql"