FunctionsType Conversion

to_date_or_zero

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

to_date_or_zero(…) → Date

Kind · scalar

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

Part of the Type Conversion family.

to_date_or_null

Converts values to Date day offsets and returns NULL when conversion fails.

to_date_time_or_default

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