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

SQL
1

postgres convert text to number

SELECT ' 5800.79 '::INTEGER;
Posted by: Guest on January-21-2021
0

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 "SQL"

Browse Popular Code Answers by Language