FunctionsType Conversion

to_datetime_or_zero

Converts values to DateTime epoch-seconds and uses 0 when conversion fails.

to_datetime_or_zero(…) → DateTime

Kind · scalar

Converts values to DateTime epoch-seconds and uses 0 when conversion fails.

Part of the Type Conversion family.

to_datetime_or_null

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

to_datetime32

Converts values to DateTime32-compatible epoch seconds. Out-of-range values return NULL.