FunctionsType Conversion

to_last_day_of_month

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

to_last_day_of_month(…) → Date

Kind · scalar

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

Part of the Type Conversion family.

to_ipv6_or_zero

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

to_low_cardinality

Produces a canonical textual representation suitable for low-cardinality dictionary encoding.