PostgreSQL Type Casts

In PostgreSQL, Type Casts converts a value from one data type to another specified data type. This can be done explicitly using the CAST() function and the :: operator.

Syntax

CAST() function:

CAST(value AS target_data_type)

:: operator:

value::target_data_type

Examples

Example 1

Casting a floating-point number to an integer using the CAST() function:

SELECT CAST(37.8 AS INTEGER);

Copy to clipboard
Copy to clipboard

Output:

Example 2

Casting a string to a date using the CAST() function:

SELECT CAST('Wed 22 May 2024 18:33:55' AS DATE);

Copy to clipboard
Copy to clipboard

Output:

Example 3

Casting a string to a floating-point number using the :: operator:

SELECT '22.5'::FLOAT;

Copy to clipboard
Copy to clipboard

Output: