Answers for "cast bigint to float in postgresql"

postgresql convert text to float

select cast('132342' as double precision);

Posted by: Guest on December-23-2020

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 "cast bigint to float in postgresql"