Answers for "why can't i cast text as number in postgresql"

postgres convert text to number

SELECT ' 5800.79 '::INTEGER;

Posted by: Guest on January-21-2021

PostgreSQL: To_Number function

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

Posted by: Guest on May-07-2021

Code answers related to "why can't i cast text as number in postgresql"