text to int postgres code example

Example 1: postgres convert text to number

SELECT ' 5800.79 '::INTEGER;

Example 2: postgresql convert text to float

select cast('132342' as double precision);

Example 3: postgresql cast

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

Tags:

Sql Example

Related