FunctionsType Conversion

null_if

Returns NULL if the two arguments are equal; otherwise returns the first argument. If the equality test is unknown due to NULLs, the first argument is returned (standard NULLIF behavior).

null_if(…) → Dynamic

Kind · scalar

Returns NULL if the two arguments are equal; otherwise returns the first argument. If the equality test is unknown due to NULLs, the first argument is returned (standard NULLIF behavior).

Part of the Type Conversion family.

multi_if

Evaluates condition/value pairs left to right and returns the value corresponding to the first condition that is true. If no condition is true, returns the final default argument. Useful as a compa…

reinterpret_as_date

Reinterprets the first 8 bytes of the input value as a signed integer day representation without parsing.