PostgreSQL/String Functions/to number

to_number("00123456789", "00999999999")

   <source lang="sql">

postgres=# SELECT to_number("00123456789", "00999999999") AS leading_zeroes;

leading_zeroes

---

     123456789

(1 row) postgres=#

      </source>
   
  

to_number("123,456,789.00", "999G999G999D99")

   <source lang="sql">

postgres=# SELECT to_number("123,456,789.00", "999G999G999D99") AS formatted;

 formatted

---

123456789.00

(1 row) postgres=#

      </source>
   
  

to_number("123456789", "999999999")

   <source lang="sql">

postgres=# SELECT to_number("123456789", "999999999") AS just_digits;

just_digits

---

  123456789

(1 row) postgres=#

      </source>
   
  

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

   <source lang="sql">

postgres=# SELECT to_number("$2,900.00", "L9G999D99") postgres-# AS monetary;

monetary

---

 2900.00

(1 row) postgres=#

      </source>