Mega Code Archive

 

Categories / PostgreSQL / String Functions

 

To_number($2,900 00, L9G999D99)

postgres=# SELECT to_number('$2,900.00', 'L9G999D99') postgres-#           AS monetary;  monetary ----------   2900.00 (1 row) postgres=#