Premium
Log in
PostgreSQL Function Reference
CAST
Casts a value to a specified type.
PostgreSQL 17.5
CAST(value AS type)value
The value to cast
type
The target type
Examples
PostgreSQL 17.5
SELECT CAST(12005.6 AS NUMERIC)CAST(value AS type)SELECT CAST(12005.6 AS NUMERIC)