Answers for "convert a columns to decimal postgresql"

SQL
1

postgres change column type string to integer

ALTER TABLE the_table ALTER COLUMN col_name TYPE integer USING (col_name::integer);
Posted by: Guest on June-01-2021
1

postgres cast as decimal

cast(tableA.charge_amt AS decimal(8,2)) AS charge_amt
Posted by: Guest on October-04-2021

Code answers related to "convert a columns to decimal postgresql"

Code answers related to "SQL"

Browse Popular Code Answers by Language