Mega Code Archive
Categories
/
PostgreSQL
/
String Functions
To_number(123,456,789 00, 999G999G999D99)
postgres=# SELECT to_number('123,456,789.00', '999G999G999D99') AS formatted; formatted -------------- 123456789.00 (1 row) postgres=#