substr(1234, 3) (substring the digits) : substr « String Functions « PostgreSQL






substr(1234, 3) (substring the digits)


postgres=# SELECT substr(1234, 3);
 substr
--------
 34
(1 row)

postgres=#
           
       








Related examples in the same category

1.substr: return the substring
2.substr('1234', 3)
3.substr(CAST (varchar '1234' AS text), 3)
4.substr(varchar '1234', 3)
5.substr(CAST (1234 AS text), 3)