SQL · Numeric functions

to_number()

Parses a formatted number. PostgreSQL.

sqlRunnable example sql course

Syntax

to_number(text, format)

Example

Open in the lab

SELECT cast('42' AS integer) AS number;

Reference pages are the quick answer. The course explains the why, shows the full example and ends with a challenge.