to_number('$2,900.00', 'L9G999D99') : to_number « String Functions « PostgreSQL






  1. PostgreSQL
  2. String Functions
  3. to_number

to_number('$2,900.00', 'L9G999D99')

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

postgres=#








Related examples in the same category

1.to_number('123,456,789.00', '999G999G999D99')
2.to_number('123456789', '999999999')
3.to_number('00123456789', '00999999999')