SQL · Functions and expressions

cast()

Converts between types. Use it explicitly rather than relying on implicit casts.

sqlRunnable example sql course

Syntax

cast(value as type)

Example

Open in the lab

SELECT cast('42' AS integer) + 1 AS answer;

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