FunctionsType Conversion

to_decimal256_or_zero

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

to_decimal256_or_zero(…) → Decimal256

Kind · scalar

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

Part of the Type Conversion family.

to_decimal256_or_null

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

to_decimal32

Converts values to Decimal32-compatible scaled integers. Optional second argument sets decimal scale.