to_number('123,456,789.00', '999G999G999D99') : to_number « String Functions « PostgreSQL

1. PostgreSQL
2. String Functions
3. to_number

to_number('123,456,789.00', '999G999G999D99')

postgres=# SELECT to_number('123,456,789.00', '999G999G999D99') AS formatted;
  formatted
--------------
 123456789.00
(1 row)

postgres=#
           
       

Related examples in the same category