Cast functions and operators

Use the cast function and operator to convert a value to a specific type.

Syntax

cast ( value AS type )

value :: type

Parameter	Description
value	The value to be converted.
type	The data type of the returned value. For the types you can cast the value to, see Data types.

Example

SELECT '2049-01-01 23:34:56+08:00'::timestamp with time zone::varchar;

2049-01-01T15:34:56+00:00