FunctionsType Conversion

reinterpret_as_date

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

reinterpret_as_date(…) → Date

Kind · scalar

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

Part of the Type Conversion family.

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).

reinterpret_as_date_time

Reinterprets the first 8 bytes of input as a DateTime-compatible signed integer without text parsing.