to_number('00123456789', '00999999999') : to_number « String Functions « PostgreSQL






  1. PostgreSQL
  2. String Functions
  3. to_number

to_number('00123456789', '00999999999')


postgres=# SELECT to_number('00123456789', '00999999999')       AS leading_zeroes;
 leading_zeroes
----------------
      123456789
(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('$2,900.00', 'L9G999D99')