Answers for "text to int postgres"

postgresql convert text to float

select cast('132342' as double precision);

Posted by: Guest on December-23-2020

postgres convert text to number

SELECT ' 5800.79 '::INTEGER;

Posted by: Guest on January-21-2021

postgresql cast

SELECT '100'::INTEGER;
SELECT CAST ('100' AS INTEGER);

Posted by: Guest on October-12-2020

Code answers related to "text to int postgres"