FunctionsType Conversion

cast_as_int

Casts the input value to Int64. Values outside the signed 64-bit range yield NULL.

cast_as_int(…) → Int64

Kind · scalar

Casts the input value to Int64. Values outside the signed 64-bit range yield NULL.

Part of the Type Conversion family.

cast_as_inet

Casts the input value to an IP string. Supports IPv4/IPv6 text and UInt32-like numeric IPv4 input.

cast_as_smallint

Casts the input value to 16-bit signed range. Out-of-range values yield NULL.