FunctionsType Conversion

to_decimal128_or_null

Converts values to Decimal128-compatible scaled integers and returns NULL when conversion fails.

to_decimal128_or_null(…) → Decimal128

Kind · scalar

Converts values to Decimal128-compatible scaled integers and returns NULL when conversion fails.

Part of the Type Conversion family.

to_decimal128_or_default

Converts values to Decimal128-compatible scaled integers and falls back to a provided default when conversion fails.

to_decimal128_or_zero

Converts values to Decimal128-compatible scaled integers and uses 0 when conversion fails.