FunctionsType Conversion

to_ipv6_or_zero

Converts values to canonical IPv6 text and uses :: when conversion fails.

to_ipv6_or_zero(…) → IPv6

Kind · scalar

Converts values to canonical IPv6 text and uses :: when conversion fails.

Part of the Type Conversion family.

to_ipv6_or_null

Converts values to canonical IPv6 text and returns NULL when conversion fails.

to_last_day_of_month

Returns the last calendar day of the month that contains the input date or timestamp.