FunctionsType Conversion

to_decimal64_or_zero

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

to_decimal64_or_zero(…) → Decimal64

Kind · scalar

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

Part of the Type Conversion family.

to_decimal64_or_null

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

to_fixed_string

Converts inputs to fixed-length byte strings. Values shorter than the requested size are zero-padded; longer values are truncated.