Answers for "postgres cast varchar as numeric postgres"

SQL
1

postgres convert text to number

SELECT ' 5800.79 '::INTEGER;
Posted by: Guest on January-21-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 "SQL"

Browse Popular Code Answers by Language