FunctionsType Conversion

to_datetime_or_default

Converts values to DateTime epoch-seconds and falls back to a caller-provided default when conversion fails.

to_datetime_or_default(…) → DateTime

Kind · scalar

Converts values to DateTime epoch-seconds and falls back to a caller-provided default when conversion fails.

Part of the Type Conversion family.

to_date32_or_zero

Converts values to Date32 day offsets and falls back to 0 when conversion fails.

to_datetime_or_null

Converts values to DateTime epoch-seconds and returns NULL when conversion fails.