to_number « String Functions « PostgreSQL






  1. PostgreSQL
  2. String Functions
  3. to_number
1.to_number('123,456,789.00', '999G999G999D99')
2.to_number('123456789', '999999999')
3.to_number('00123456789', '00999999999')
4.to_number('$2,900.00', 'L9G999D99')