postgresql string to number code example

Example 1: postgres convert text to number

SELECT ' 5800.79 '::INTEGER;

Example 2: PostgreSQL: To_Number function

SELECT
    TO_NUMBER(
        '12,345.6-',
        '99G999D9S'
    );Code language: JavaScript (javascript)