Answers for "postgresql decimal to integer"

postgres cast as decimal

cast(tableA.charge_amt AS decimal(8,2)) AS charge_amt

Posted by: Guest on October-04-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 "postgresql decimal to integer"